Text Formula Column Not Updating: Solutions and Discussion | Clay

Text Formula Column Not Updating: Solutions and Discussion

Hi guys, is anyone else slowed down by the text formula column not updating itself? I always have to reset it to the original value. Is anyone else experiencing this problem or has a solution for it? Do you have any suggestions here "the legend" Yash T. ? 🙂

14 comments

Channeled
APP
·
·
The text formula column in Clay may not be updating itself because it's not set to the correct input type. To fix this issue, you need to switch the column input type from "Text with tokens" to "Formulas". Here's how you can do it: 1. Click on the header of the column you want to edit. 2. Select 'Edit column' from the dropdown menu. 3. Click on the gear icon and choose 'Formulas' as the new input type. 4. Press 'Save settings' to apply your changes.Once you've set the column to use the Formula input type, you can add a new formula by typing out what you'd like to do inside the AI Formula Generator box. Use "/" to reference other columns in your condition, then click 'Generate Formula' and 'Save Formula' after reviewing the sample output.Could you provide more details about the specific formula you're trying to use? This would help me offer more targeted advice for your situation. Sources: Formulas Table columns overview | Documentation | Clay University
Ilayda A.
·
·
I use this in my enrichment process, so I need the text to always remain in the same column since it’s a data point. The table is active and constantly receives data, but each new entry is missing the text. I have to either reset it to the original value or paste the value manually every time. It's quite frustrating. Does anyone know a solution for this? 🙂
Channeled
APP
·
·
Looks like you're still looking for help. We're escalating this over to our support team and someone should be in touch soon. In the meantime, feel free to include any other information that may be helpful in solving your issue!
Ilayda A.
·
·
LuisArturo
·
·
Hey there Ilayda thanks for reaching out, do you mind sending the link to the table so we can take a look? https://downloads.intercomcdn.com/i/o/1171717996/ac7729f84b426e1d0358af02/image.png?expires=1736889300&signature=2c22839083029f07253a51cad6a37ebc129b917aed5278d5f46a5d4b06246a61&req=dSEgF85%2FmohWX%2FMW1HO4zYTywS30Dp4V2BKsam%2FhVPssmg%3D%3D%0A
🙌1
🥰1
Ilayda A.
·
·
https://app.clay.com/workspaces/424056/workbooks/wb_D5hkSwiimu5Q/tables/t_3sTQo7sSEDBg/views/gv_TCP7XaP5Uvp5
LuisArturo
·
·
I see normally when this issue occurs its because the formula needs a trigger to run. So in this case a simple fix for this would be to add something like this to the beginning of the formula section "If /Company Name has a value then...". This will make so that the formula always checks to make sure that the Company name column has a value and if it does to return the body of text.
Ilayda A.
·
·
Ilayda A.
·
·
Ilayda A.
·
·
Then I get infinite loop bug
LuisArturo
·
·
I see what happened since the column you are writing this formula in is "Large E Criteria" it would cause this loop to occur. That is why it is better to use another column such as Column name instead.
Ilayda A.
·
·
I tired that too it doesn't even pass info to another column.
Ilayda A.
·
·
Thanks figured :)
Channeled
APP
·
·
Hi Ilayda A.! This thread was recently closed by our Support team. If you have a moment, please share your feedback: