Home
Events
Groups
Members

00 Clay Announcements
01 Community General
01 Props and Wins
01 Watercooler
01 Welcome and Intros
02 Bugs
02 Starting with Clay
02 Support
03 Feedback & Requests
03 Tutorials & Inspiration
04 FT Job Opps
Gtm Career Advice
Member Spotlight

Community Guidelines

Powered by Tightknit

Why Do Formulas Stop Working After 200 Rows?

Michael Baldevia

·

·

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

Why Do Formulas Stop Working After 200 Rows? | Clay

6 comments

· Sorted by Oldest

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 Baldevia
·
·
https://app.clay.com/workspaces/102117/workbooks/wb_0swcx9ydP3t3zdmbdGy/tables/t_0swcx9yFRNf3SrxB7Pp/views/gv_0swcx9yroQebukM38K2
LuisArturo (Clay)
·
·
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 Baldevia
·
·
Thanks LuisArturo (Clay)!
LuisArturo (Clay)
·
·
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 Baldevia
·
·
Thank you so much for the update LuisArturo (Clay)!