Formula Columns Not Updating Values for New Rows in Table

Nick S.

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

28 comments

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)
Clay Team
APP
·
·
Seems that is not a problem of an input coming from another table
Clay Team
APP
·
·
I will create a prompt for the AI to do this
Nick S.
·
·
OK thanks, I might be hitting my column limit though, can you enable another column so that I can see the prompt in it? as I don't wanna risk overwriting what I already had working
Clay Team
APP
·
·
I'm afraid I can't do this... as a workaround you can continue your work wrtiting to another table, as you already did
Nick S.
·
·
I'll copy the formula, go ahead with writing the ai prompt for it to replace what's there 👍
Nick S.
·
·
hey Juan, any update on this, I don't see an ai prompt yet?
Clay Team
APP
·
·
I can't access the table, has this being deleted? can you repost the link here?
Nick S.
·
·
https://app.clay.com/workspaces/207112/tables/t_FOsoEHuQCF4Q/views/gv_cHw3v66dn7Mo it's the subject line column
Clay Team
APP
·
·
I'm afraid AI is not going to fix this, can you try spliting the formulas and the conditionals in different columns? at the end you can merhe all in one column
Clay Team
APP
·
·
Sorry for the change of opinion but now I'm realizing that this will be a prompt to complex
Nick S.
·
·
that would cost 4 columns though Juan, I don't have the capacity for that
Nick S.
·
·
any ideas? also is clay back up and running yet?
Clay Team
APP
·
·
Clay should be working properly now, for the columns you can create a support table with lookups