Guys, this is a HUGE problem, HUGE. My checkbox formula stopped working all of a sudden. It already happened one time before and I fixed it by adding another formula. Please take a look at the vide below. I recorded everything you need to know. Table link: https://app.clay.com/workspaces/476674/workbooks/wb_0t4wuvhENFCK8BEFawc/tables/t_0t4yechdnGt4YzDqheh/views/gv_0t4yeciBnNgrT9iM3q4 https://www.loom.com/share/e9e87d364c20413885a09aa236669ab7 This is literally ruining our clients's campaigns. We can't allow mistakes like this on scale. Please get back to me today!
First, try a hard refresh using Cmd/Ctrl + Shift + R to resolve formula evaluation issues.
If that doesn't work, click the column header of your checkbox formula column and select Force Rerun Column to jump-start it.
For formula issues, check if your formula assumes data exists in every row. Add conditional logic like "if {{response}} exists..." to prevent errors when data is missing.
You can also use our Troubleshoot with AI feature - click any error cell and select it for instant debugging instructions.
Click into the specific cells showing errors to see detailed error messages for better troubleshooting.
Did that answer your question?
I hope the suggestions helped resolve the checkbox formula issue, and I apologize again for the trouble this has caused. Would you like to provide more details about what you're trying to fix so I can assist you further?
This happens all the time to me with my formulas. They basically stay null unless I force run them. I think that when multiple rows get inserted quickly, this seems to happen ... I wonder if theres a way to delay and wait for the lookup to be finished before moving forward ahead with the other columns.
Yes, you can control timing between columns! Use "Only run if" conditions in Run Settings to make formulas wait for lookups to complete.
For better control, create a formula column using Clay.getCellStatus({{field_id}}) to check if your lookup column finished processing, then set your checkbox formula to only run when that status shows complete.
You can also add delay columns between steps - each creates about a 10-second pause to give lookups time to finish before the next column runs.
Also consider turning off auto-update while building your table to prevent premature runs when adding multiple rows quickly.
Was that helpful?
I understand this timing issue is really impacting your work. Let's get this sorted out permanently.
Since this happens consistently when adding multiple rows quickly, try disabling auto-update at the table level while building your workflow. This prevents premature runs when rows are added rapidly.
For a more robust solution, set up proper sequencing:
Create a formula column using Clay.getCellStatus({{lookup_field_id}}) to monitor your lookup completion
In your checkbox formula's Run Settings, add an "Only run if" condition that waits for the lookup status to show "complete"
This ensures your checkbox formula never runs until the lookup is actually finished, eliminating the null results.
Are you comfortable setting up the getCellStatus formula, or would you like me to walk through that specific setup?
No that's not helpful. The problem is the formula that stops working all of a sudden
I'm sorry to hear this is so frustrating. I'll connect you to a human agent who can assist you further.
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Hello Petar! Thanks for reaching out! I apologise for the issues you are facing and will try my best to help you out here. I took a look at your table and can see that the formula column has hence been returning checked for records where an email was found. What changes did you make? You also mentioned you had another table you faced this issue in. I would like to take a look to get an understanding of why this happened. I have my suspicions on this one issue we have been tackling for which we do have a temporary fix while we work on something more permanent. However I will have to take a look before i reach out to the engineers to apply that fix on this workspace.
Is there any way you can check with your engineering team without the proof?
I also have another problem that's not being solved in this table. Maybe you can take a look into that:
