Updated Column Causing Formula Errors and Data Flags
hi there - i have a column i updated and now all the cells are flaged as out of data and the formulas referencing the true or false in the cells are no longer pulling the data
hi there - i have a column i updated and now all the cells are flaged as out of data and the formulas referencing the true or false in the cells are no longer pulling the data
This happens when you save a formula without running enrichments - the cells appear greyed out to indicate they're out of date. [1] When auto-update is turned off, downstream columns (like your formulas referencing true/false values) won't refresh with the latest data.
To fix this, you can either:
Toggle auto-update off and on again, then accept the run prompt to update all rows
Right-click the column and select "Run column" to manually trigger it
What type of update did you make to the column - was it a formula change or something else?
it was a conditionality update
we can't re-run the column because it's 40k cells
I understand the challenge with 40k cells - that's a lot to re-run. For conditional updates specifically, you have a few options that don't require running the entire column:
You can disable auto-update for the column to prevent future unexpected updates, then use a formula column with Clay.getCellStatus(#{{field_id}}) to check the status of your conditional column and control which downstream formulas should update.
Alternatively, you could create sequential workflows where your dependent formulas only run when specific conditions are met using "Only run if" settings, which gives you more control over what gets updated.
What specific conditional logic did you change - was it the "Only run if" criteria or something else in the run settings?
can i still get the data from the out of date cells?
Yes, you can still access the data from out-of-date cells. The data remains in those cells even when they're flagged as out of date - the greyed out appearance just indicates they haven't been refreshed since your conditional update.
Your formulas referencing the true/false values should still be able to pull from these cells. The issue might be that your downstream formulas are also set to auto-update and are waiting for the conditional column to refresh first.
Try checking if your dependent formulas are still pulling the existing data, or if they've also been marked as needing updates due to the conditional change.
Did that answer your question?
no i created a column from the output and it's not pupulating with the data from the out of date cell
I'm sorry for the trouble you're experiencing. I'll connect you to one of our human agents who can assist you further with this issue.
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!
im working on counting the true/false outputs from solumen 4.1 S5-v1-IA-EL and the column was updated to include conditionality so we don't have any gaps b/c argon isn't working
Hey Nicholas- just so I can get more clarity on this. Have you tried adding the True or False outputs from the Claygent cell to the table as a column? Because it's nested in, the formulas referencing those true and false values may error out. Please let me know if that ends up working!
Yes twice
Is the issue that when you add the column, it doesn't populate with data? or that the column referencing it doesn't populate with data?