Conditional Column Setup: Handle Error in Lookup Function

Mark J. · 2025-04-28T18:37:47.379301+00:00

I'm trying to set up a column so that it only runs if another column dooes not have data AND that column did not return an error. I'm using this formula for the conditional: !{{Lookup Contact by LinkedIn}} That correctly returns true if the {{Lookup Contact by LinkedIn}} column did not return results, but it also returns true if the reference column returned an error.

To set up a column that only runs if another column doesn't have data and didn't return an error, you can use a more specific conditional run formula. Here's how: 1. Click on "Run Settings" for your column. 2. Select "Conditional Run." 3. Use the AI to generate a formula like this: isblank({{Lookup Contact by LinkedIn}}) && !iserror({{Lookup Contact by LinkedIn}}) This formula checks if the "Lookup Contact by LinkedIn" column is blank (no data) AND not an error. It will only return true if both conditions are met, ensuring your new column runs only when needed. Remember, you can use the "Use AI" button to help generate and refine these formulas for your specific needs.

Sources: AI Formulas + Conditional Runs [CRM Enrichment] - Clay University AI Formulas + Conditional Runs [Clay 101] - Clay University

3 comments