Home

Clay Announcements
Clay Support
Discuss Anything
Feedback & Requests
GTM Career Advice
Introduce Yourself
Member Spotlight
Share Content and Events
Share Full-time Jobs
Share Part Time Jobs
Share Tables, Tools, and Workflows

Community Guidelines

Explore Events
Clay Cup

Powered by Tightknit

Waiting for Formula Outputs in Columns Before Final Result | Clay

Waiting for Formula Outputs in Columns Before Final Result

·May 13, 2025 05:23 PM·

hey team sorry for the repetitive question on this but still haven't figure it out yet: How do I ask the Fomula to wait for Columns to finish running before having an output? I have the Formula to output Qualified if all four Look Up columns return no results but it has to wait for them to finish running first. https://app.clay.com/workspaces/449716/workbooks/wb_0svhr5rciU5UhYbN9Xv/tables/t_0svhrd2PXywV3cgRzt9/views/gv_0svhrd4hPGy49Gks8cJ

1 comment

· Sorted by Oldest

Channeled
APP
·
·
To make a Formula wait for Look Up columns to finish before outputting a result, you can use a conditional run formula. Here's how: 1. Create a boolean formula to check if all Look Up columns have finished running. 2. Use this boolean in a conditional formula for your "Qualified" output. For example: LBKSIF(AND( NOT(ISBLANK(LookUp1)), NOT(ISBLANK(LookUp2)), NOT(ISBLANK(LookUp3)), NOT(ISBLANK(LookUp4)) ), IF(AND( ISEMPTY(LookUp1), ISEMPTY(LookUp2), ISEMPTY(LookUp3), ISEMPTY(LookUp4) ), "Qualified", "" ), "" )LBKSThis formula will only output "Qualified" when all four Look Up columns have finished running and returned no results.
Sources: Enrichments | Documentation | Clay University Conditional runs | Documentation | Clay University