Happy Friday! I have 6 personas (saved people searches of titles) in clay. I'm building a table to Find People. And I want to add all six of those personas, but I want to prioritize them. Example: there's a persona that is CTO, I want to prioritize that over the IC Eng Persona. I want to have up to 10 people, and so I basically just want to say, hey, I want the 10 most important titles added first. So, if you can't fill those 10 slots using persona 1 (CTO), then I want you to go look into persona 2 and keep going down the six personas until we've got 10 people that we found at one particular company. How do I build that inside of clay?
You can build this prioritized search using multiple Find People columns with conditional runs. Set up 6 separate Find People columns, one for each persona in priority order. [1]
This creates a waterfall effect where Clay searches your highest priority persona first, then moves to the next only if needed, until you reach 10 people total. [4]
Before diving into the setup, I'd recommend trying Sculptor (top-right corner) - it can help you build this prioritized workflow quickly and might save you time setting up all the conditional logic manually.
Is that what you were looking for?
If you need any more help setting up your prioritized personas or using Sculptor, I’m here to assist. Would you like to share more details about what you’re trying to achieve or any challenges you’re facing?
got it, thanks! i’ll try this out and let you know if i get stuck!
Great! Take your time trying it out, and feel free to reach out if you need any more help or run into any issues.
that did not work. i think it's because the Cell details are not able to become dedicate columns. is there anyone way to do this?
You're right - the issue is that Find People columns return complex objects, not simple counts that work well in conditional formulas. [1]
Try this approach instead:
Create a formula column after each Find People column to extract the count: {{Your Find People Column}}?.people?.length || 0
Use these count columns in your conditional runs instead of the raw Find People data
Set up your conditional logic like: "only run if previous count columns total less than 10" [2]
This gives you dedicated count columns that work properly in conditions. You can also use Clay.getCellStatus() to check if previous columns completed successfully.
Before diving deeper into the manual setup, I'd really recommend trying Sculptor (top-right corner) - it's designed to handle exactly this type of prioritized workflow and might save you a lot of time with the conditional logic.
If you still need help refining your prioritized personas setup or using Sculptor, I’m here to assist. Would you like to provide more details about the challenges you’re facing so we can continue troubleshooting?
The formula looks correct, but the issue is that "People Search Updated" means the search completed but found 0 people - so the count is working properly. [1]
For your prioritized workflow, try Sculptor (top-right corner) - it's designed exactly for this type of conditional logic setup and will handle the complex conditional runs automatically.
If you want to continue manually, the conditional runs should check if the total count across all previous personas is less than 10, not individual column counts. [2]
Is that what you were looking for?
Thanks for sharing these details—I’ll connect you with a human agent who can help troubleshoot this further. We appreciate your patience.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Hey Brendan, that data point is not something you are able to extract from the cell details there. Hence, the formula is not returning the right results.
