Question: Can you help me check this table, when i turn off auto update and updated my formula, then turn it back on, I noticed the formula will also be backdated to the latest formula, is this a current behavior? Or how can i prevent it. (the formula is the column "Valid Lead?"
When you turn off auto-update, make changes to your formula, and then turn auto-update back on, Clay will run the latest version of your formula on all relevant rows, updating them to match the new logic. This is the intended behavior to ensure consistency across your table. To prevent this, consider using conditional run criteria so the formula only updates under specific conditions, or keep auto-update off if you want to avoid retroactive changes. Are you looking to update only new rows with the latest formula while keeping existing rows unchanged?
Yes, but i thought turning off the auto-update features will not allow any new rows to run?
When auto-update is turned off, new rows added to your table will not automatically run formulas. This is exactly what you want to prevent backdating. To update only new rows with your latest formula while keeping existing rows unchanged: 1. Turn off auto-update for the specific column (via Run Settings) or the entire table (click the three dots next to your table name) 2. Make your formula changes 3. Manually run the formula only on new rows when needed For more selective control, use conditional run criteria in your formula's Run Settings to specify exactly which rows should update.