Why Do Formulas Stop Working After 200 Rows? | Clay

Why Do Formulas Stop Working After 200 Rows?

Hello Team, Is there any reason that formulas stop working after running a certain number of rows? as a Context I added a formula to clean up some Phone and Mobile number but it suddenly stopped working after 200 rows. Here's the table https://app.clay.com/workspaces/102117/workbooks/wb_0swcx9ydP3t3zdmbdGy/tables/t_0swcx9yFRNf3SrxB7Pp/views/gv_0swcx9yroQebukM38K2

6 comments

Channeled
APP
·
·
There are several reasons why your phone number cleaning formula might have stopped working after 200 rows: 1. Loading delays - Larger tables can take longer to update, causing empty spaces to appear temporarily. 2. Formula logic issues - If your formula assumes data exists in every row but some rows are missing that data, it can cause the formula to stop working properly. 3. Performance limitations - When working with large tables or complex workflows, you might experience latency issues where cell data takes longer to load. To fix this: 1. Try adding conditional logic to your formula (e.g., "if {{response}} exists...") so it only processes rows with data. 2. For rows where the formula didn't work, create a new column by duplicating your current one, filter for empty rows, and run it again on those. 3. Use the "merge columns" feature to combine the results afterward. 4. You can also try clicking "re-run this cell" on affected rows or toggle the auto-update off and on again.
Michael B.
·
·
https://app.clay.com/workspaces/102117/workbooks/wb_0swcx9ydP3t3zdmbdGy/tables/t_0swcx9yFRNf3SrxB7Pp/views/gv_0swcx9yroQebukM38K2
LuisArturo
·
·
michael - Sorry for this, it looks like we've got a bug on our hands. I've escalated this to our engineering team to help look into it. We'll follow up here as soon as we know more!
Michael B.
·
·
Thanks LuisArturo!
LuisArturo
·
·
Good news! Happy to report that we heard back from the team and this issue should be fixed. Try a quick refresh (Cmd/Ctrl + Shift + R) and let us know if the problem has been resolved on your end, or if you still have trouble. Thank you for your patience as we worked on it.
Michael B.
·
·
Thank you so much for the update LuisArturo!