Troubleshooting Single Row Lookup and Delayed Conditions in Tables

Mackenzie S. · 2025-11-14 23:41:36.073901+00

I am having a trouble with single row look up and retrieving information from one table to another. Basically the Lookup is beating my AI on that table and so its not pulling the values because they aren't there when the look up is ran initially so i just have to rerun it. • is there a way to delay a look up? • is there a way to have a condition looking at a value at another table? Any help or feedback is appreciated please. Video attached in the thread.

Mackenzie S.
·
·
https://www.loom.com/share/0d31a55e7f6e481785cdd38c000fd4c0
Clay Support
APP
·
·
You can delay a lookup in Clay by adding a delay column between dependent steps—each delay column adds about 10 seconds. To ensure a lookup only runs when data is available, use the "Only run if" condition in the column’s run settings. You can reference values from other tables using formula columns like Clay.getCellStatus({{field_id}}) to check if required data is present before running the lookup or AI step. This helps sequence your workflow and avoid missing data issues. [1] [2] [3]
Clay Support
APP
·
·
Did that explanation help with your lookup issue?
Mackenzie S.
·
·
I would like to know more about the formula
Clay Support
APP
·
·
To conditionally run lookups based on values from another table, you can use a formula column with Clay.getCellStatus({{field_id}}). This checks if a specific column (like a lookup or AI column) has finished processing, is empty, or has an error.
How to set it up:
Add a formula column and use Clay.getCellStatus(#{{field_id}}) to reference the status of another column.
In the "Run Settings" of your lookup or AI column, set an "Only run if" condition using the formula column. For example, only run if the status is "completed".
This ensures your lookup or AI step only runs when the required data is available, helping you avoid missing values and sequence your workflow properly. [1] [2]
Clay Support
APP
·
·
Does that help explain the formula usage?
Clay Support
APP
·
·
If you still need help with using the formula or setting up conditional lookups, I’m here to assist. Would you like to provide more details about what you’re trying to achieve or any specific challenges you’re facing?
Mackenzie S.
·
·
where do i get the field id
Clay Support
APP
·
·
To get the field ID for use in Clay formulas, open your Clay table and look at the URL in your browser. The field (column) ID appears in the URL after "tables/TABLEID/columns/COLUMNID". You can copy this COLUMNID and use it in your formula, like Clay.getCellStatus(#{{field_id}}). This lets you reference the status of that specific column for conditional lookups between tables.
Clay Support
APP
·
·
Did that help you find the field ID?
Mackenzie S.
·
·
and i can look at a column from another table?
Clay Support
APP
·
·
You can reference columns from another table in Clay by using the Lookup Rows feature. Set up a lookup column to pull data from your target table, then use formulas or the “Only run if” condition in run settings to trigger actions based on the retrieved values. This lets you create conditional logic that depends on data from other tables, making your workflow more dynamic. [1] [2] [3]
Clay Support
APP
·
·
Did that explain how to reference other tables?
Mackenzie S.
·
·
Can i please talk to someone?
Clay Support
APP
·
·
I understand you'd like to speak with a human agent, so I’m routing you to our team now for further assistance.

24 comments