Formula Columns Not Updating Values for New Rows in Table

Nick S.

·Feb 09, 2024 10:28 AM·

My formula columns don't seem to update the formula column values for new rows that are written into my table

28 comments

· Sorted by Oldest

Nick S.
·
·
https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo Check the subject line column
Nick S.
·
·
also the verified master emails column
Clay Team
APP
·
·
Hi Nick, your formula is invalid, maybe if you split this in diffrent columns with clearer prompts? also, there is an specyfic feature to merge columns. I notice that the auto update cells is turned off
Nick S.
·
·
ignore the verified master one for now
Nick S.
·
·
I'm working on that
Nick S.
·
·
but the column subject lines hasn't created values for the new rows that were just written
Nick S.
·
·
how do I get the formula to run and populate valuues for the column on new rows that are written to the table?
Nick S.
·
·
need some help on this asap so I can push the leads to my campaigns
Clay Team
APP
·
·
I'm checking the table Nick
Clay Team
APP
·
·
This formula is too long and to complex, AI will do a better job
Nick S.
·
·
is the problem with the values not populating down to formula complexity? because it seems to be working fine on rows that were native to the table, just not with the new rows written to the table from another table
Clay Team
APP
·
·
I think the problem is due to the complexity of the prompt, it should not be a problem if the columns are written from another table
Nick S.
·
·
have you tested to see if the same thing occurs with simple formulas? as I remember a while back this was happening on my "company domain" formula column, and I don't remember that being super complex Just wanna know before spending time on restructuring things
Clay Team
APP
·
·

3fd04909-55b0-45d1-9523-f58b3e53f2f7.png(70 kB)
Clay Team
APP
·
·

18ef589e-e997-4d42-986e-9c519800c46d.png(14 kB)