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
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", "" ), "" )LBKS
This formula will only output "Qualified" when all four Look Up columns have finished running and returned no results.