Troubleshooting Error Evaluating Formula in Workbook Merge Process | Clay

Troubleshooting Error Evaluating Formula in Workbook Merge Process

Hey Team, I’ve been using the same table at scale duplicating it and creating a new version for the same process without issues for the last 30 workbooks. Randomly these errors started appearing “Error evaluating Formula” and they go away when I run the enrichments I have, but have impacted the functionality of a critical merge column, as it no longer outputs anything. Nothing has changed though? Is there something I’m missing. I have tried logging out, hard refresh etc. This is something I need to overcome quickly and would appreciate any help! I can provide the a table ID upon request via DM! Thanks!

13 comments

Channeled
APP
·
·
The "Error evaluating Formula" issue you're encountering might be due to how your formula is set up. It's possible that the formula is assuming there's a response for every row, which isn't always the case. This can lead to errors that prevent the merge column from outputting as expected. To resolve this: 1. Refresh your browser using Cmd/Ctrl + Shift + R. 2. If the issue persists, modify your formula to include a conditional check. Add logic like "if {{response}} exists..." to ensure the formula only acts on response data when it's available. 3. For the merge column, you may need to re-update the data and consider adding a conditional run setting to only process when all variables are present. These steps should help resolve the formula errors and get your merge column functioning correctly again.
Bo (.
·
·
Hey Joe, I'm very sorry about this issue. Can you send me the table URL where you're seeing these errors?
We experienced a temporary bug today that was causing formula problems, but usually re-adding the enrichment to the table should fix it. Don't worry about sharing the table URL here - it's completely private and only our team can access it.
Joe S.
·
·
https://app.clay.com/workspaces/506019/workbooks/wb_XJTGooZoWti9/tables/t_5Wirq9oNJiu2/views/gv_gPU93GXd5WBY
Joe S.
·
·
Here is an example of the same kind of table with the same data and no errors https://app.clay.com/workspaces/506019/workbooks/wb_mbXMfSwPdyZq/tables/t_YzyCS7KwYDgg/views/gv_f4df29zCmoVU
Joe S.
·
·
Thanks Bo!
Bo (.
·
·
I recorded this walkthrough video showing exactly how to set this up: https://cln.sh/TCFBy2gM Let me know if you have any follow-up questions!
🙌1
Joe S.
·
·
Waiting for it to upload!
Joe S.
·
·
Hey Bo the video still hasn’t uploaded - can you record a loom?
Joe S.
·
·
Won’t upload for some reason
Bo (.
·
·
Hey Joe - Sorry for this. Here's the new video: https://cln.sh/FztBzc1Z
Joe S.
·
·
Hey bo - thankfully the bug solved itself overnight or there was enough time for the system to restart. In order to fix the broken tables I just deleted all rows in the enrichment table and then re-imported and it worked! Thanks for recording a separate fix!
Bo (.
·
·
Sweet! Sorry for this again, Joe! Have a great end of the week! 🎊
Channeled
APP
·
·