There are a few ways to fix formula issues:
1. If your formula assumes data exists in every row but some rows are empty, add logic to check if the data exists first (e.g., "if {{response}} exists...").
2. Try refreshing your browser with Cmd/Ctrl + Shift + R to resolve "Error evaluating formula" issues.
3. Iterate on your formula by adjusting the wording or modifying the code. Use the preview feature to ensure you're getting the right data before applying it.
If you need more specific help, please share your formula and the error you're seeing.
Hi Loh, apologies for the delay.
It should have worked correctly. I just tried generating the same formula in your table and it is working. I have attached a video showcasing the steps I took!
I hope this help, let me know if you have further questions :)
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.
How to Fix Incorrect Formula Results in Your Workbook | Clay
.png){kind=logo}
