Join the Community

Home
Directory
Events

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps

Community Guidelines

Powered by Tightknit

Waiting for Formula Outputs in Columns Before Final Result

·

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

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

Waiting for Formula Outputs in Columns Before Final Result | Clay