Hello, I have a simple yet challenging problem here. For brevity's sake, let's just say I'm starting with a company LinkedIn URL. I have an enrichment column that scrapes it: “Company Data” I have an evaluation column that determines whether it meets a particular criteria YES or NO: “Evaluate” Then I have another column that simply has that result: “Results” and EVERY CELL either has a YES or a NO. Then, in my email validation column, it is ONLY supposed to update IF, the Result value is YES. However, when I put that formula into the update logic as a required condition and “preview” the formula, it ends up returning SOME of the rows as null values, even though they ALL have either a yes or a no. Why is that happening ?
This sounds like a timing issue where your email validation column is trying to run before the "Results" column has fully completed processing.
The formula is likely checking for the condition while some rows still show as "processing" or haven't finished updating, causing them to appear as null in the preview.
Try adding a check to ensure the Results column has completed before running your email validation. You can use Clay.getCellStatus({{Results_field_id}}) in your conditional formula to verify the Results column is done processing.
Also make sure to handle empty or missing data properly in your conditional statement - even if every cell should have YES/NO, edge cases can cause unexpected nulls. [1]
What does your current conditional run formula look like exactly?
No, it's not an update problem. The entire column of yeses and nos has already been processed, and I'm simply working on the update formula for the next column. I'm in the preview in that column
I understand this is frustrating, and I’ll connect you to one of our human agents 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!
I figured out what it was. There were hidden rows with no values, but the confusion was the output window in the preview doesn't match the column order in the table
Hi,
I'm glad everything worked out! I'll go ahead and close out this ticket now, but don't hesitate to reach out again if you need any help in the future.
