Troubleshooting Formula Issues in Clay Table for Company Overview

Formaulas not working. Here's my clay table: https://app.clay.com/workspaces/16336/workbooks/wb_0svw0w2ouTVKYzFm6Cw/tables/t_0sw4gl7gKC89ASgGsgT/views/gv_0sw4gl8x5gc8QFRiZd6 Only want the "Company Overview" enrichment to run if the Random Number generated = "1". It's just not reactive and says column will not run for every row.

2 comments

Channeled
APP
·
·
To have the "Company Overview" enrichment run only when the Random Number column equals 1, use a conditional formula in the enrichment's Run Settings: 1. Go to the Run Settings for your "Company Overview" enrichment column. 2. In the “Only run if” box, enter a formula like: LBKS[Random Number] == 1LBKSReplace [Random Number] with the exact name of your column if it differs. If the formula is not reactive or you see a message like "column will not run for every row," double-check: ** The column name matches exactly (including case and spaces). ** The formula syntax is correct. ** The Random Number column is populated for all rows before the enrichment runs. If issues persist, try using the *“Use AI” button in the Run Settings to describe your condition in plain language (e.g., "Only run if Random Number is 1") and let Clay generate the formula for you. This can help avoid syntax errors and ensure reactivity. If you still encounter problems, you can request human assistance by clicking on "Talk to a person."
Sources: Guide: Ways to save Clay credits | Documentation | Clay University Apify integration | Documentation | Clay University
Daniela D.
·
·
Hey Penn! Thanks for reaching out. Happy to help✨. The "company overview" doesn't include a conditional formula. It looks like the formula generated wasn't saved/generated the wrong formula. That's why the integration ran for all rows. To unblock you, I added a formula that should ensure it runs on that condition. We'll troubleshoot the issue with the formula generator and get back with an update.
(31 kB)
(31 kB)