Troubleshooting Columns Resetting in Spreadsheet After Pasting Data

Jill M. · 2025-10-23T21:19:57.124Z

Hey Support! I pasted in a good 200 rows into a sheet and all my columns did this? Where they all ran but then they all say "Reset to Original Value"? And now I have to one at a time refresh the fields?

Troubleshooting Columns Resetting in Spreadsheet After Pasting Data | Clay

Clay Support
APP
·
·
The "Run condition not met" messages indicate your columns' run conditions aren't satisfied for those rows. This commonly happens when pasting new data if columns depend on inputs that aren't present yet.
Quick fix options:
• Toggle auto-update: Turn auto-update off and back on for the table, then accept the run prompt to update all rows.
• Force run columns: Right-click the column header → hover over "Run Column" → select "Force Run All Rows" to re-run everything at once. [1]
• Check run conditions: Click the column header → "Edit column" → review "Run settings" to ensure conditions align with your pasted data.
This should update all 200 rows without manual cell-by-cell refreshes.
Clay Support
APP
·
·
Did that answer your question?
Jill M.
·
·
The toggle update ran my entire table again and just made things exponentially worse. It did not just update the blank fields it's charging me for the full table?
Jill M.
·
·
https://app.clay.com/workspaces/745725/workbooks/wb_0t24pzuzZJuj949nDi3/tables/t_0t46u18suyFn9P4QATG/views/gv_0t46u18qNG2VhuYMDz5
Clay Support
APP
·
·
I'm sorry to hear that caused more issues. I'll connect you to a human agent who can assist you further.
Jill M.
·
·
I need to speak to a human
Jill M.
·
·
Thanks
Intercom
APP
·
·
Clay Support is sharing a file with you.
Our support team has got your message and we'll get back to you soon!
If you’re dealing with a specific table, drop the URL below so we can help you quicker. Otherwise, someone from our team will be in touch soon!
Loading attachments
Yash M.
·
·
Hi Jill - jumping in to take a deeper look here. When you turn auto-update off and then on again, expected behavior is for the entire table to rerun. This also triggers the following warning that you would have accepted before your entire table re-ran and charged credits.
Loading attachments
Jill M.
·
·
Yes but your AI stated above "Toggle auto-update: Turn auto-update off and back on for the table, then accept the run prompt to update all rows." as the solution for getting the reset to original values to stop being everywhere. Now I have a fully blank table when I already spent a ton of credits on that table to get the data.
Jill M.
·
·
I had before the toggle like 1,000+ cells to manually push Reset To Original Value for. They also would not work just by re-running the cell. I still had to manually push them
Jill M.
·
·
So basically I now am back at square one with a fully blank table and spent credits for nothing unfortunately
Donát H.
·
·
I’m experiencing the same issue. When I manually add enough rows before inserting the data, everything works fine. But if the table has fewer rows than the data I am trying to insert, the same problem occurs.
Jill M.
·
·
Ahhh Donát H. I didn't connect why this happened. That's exactly what I did too. I pasted a large amount into a single row and let it generate the new rows on the paste. Then this happened. Yash M. can we report this as a bug? Or is this expected behavior?
Yash M.
·
·
Thanks for following up Jill - let me take a deeper look here and see what's happening. I will be back with you shortly. Thanks for your patience with this!

19 comments