Troubleshooting Formula Calculation Issues in Excel

https://www.loom.com/share/04d84ffebfe64d15bc5af131742aa67e

https://app.clay.com/workspaces/7778/tables/t_x97uMSFxWv6x/views/gv_FMcMHrkan98Z

💤 You've caught us outside of our support hours (9am-9pm EST), but don't worry - we'll be back in touch within 24 hours (often sooner!). If you haven't already, please include the URL of your table in the thread below so that we can help you as quickly as possible!

Here is how i got it to work but not sure why it didn't calculate when i pasted it in: https://www.loom.com/share/08d8310231f84d32bbc534f8416cac6b

Hi David, thanks for reaching out. It seems that several cells in your formula column were overwritten manually, which likely caused the display issues with the values you were trying to view. It looks like the logic you're aiming for here is supported by our merge column feature. Here's how you can set it up: https://downloads.intercomcdn.com/i/o/1187543535/1faf771893d435179baff78e/CleanShot+2024-09-20+at+14_14_06.gif?expires=1726857900&signature=4ed7899d03f855585f65f75fd28576ce1d50f63b9ad7b74869539fc99ef37d9a&req=dSEvEcx6noRcXPMW1HO4zerWHB%2BUngsXECEvwSflALzNX%2FvIxDOUw8Pldwj8%0At%2BXv%0A I hope this was helpful. If there's anything else I can assist you with, please let me know!

We haven't heard back from you in a bit, so we're going to go ahead and close things out here - feel free to let us know if you still need something!