Troubleshooting Formula Calculation Issues in Excel

David Kreiger

·

Doesn't seem like my formula is calculating and needs to be manually run for some reason? How do i fix this?

7 comments

· Sorted by Oldest

David Kreiger
·
·
https://www.loom.com/share/04d84ffebfe64d15bc5af131742aa67e
David Kreiger
·
·
https://app.clay.com/workspaces/7778/tables/t_x97uMSFxWv6x/views/gv_FMcMHrkan98Z
Channeled
APP
·
·
💤 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!
David Kreiger
·
·
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
Bruno (Clay)
·
·
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!
Channeled
APP
·
·
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!
Channeled
APP
·
·
Hi David Kreiger! This thread was recently closed by our Support team. If you have a moment, please share your feedback:

David Kreiger
·
·
https://www.loom.com/share/04d84ffebfe64d15bc5af131742aa67e
David Kreiger
·
·
https://app.clay.com/workspaces/7778/tables/t_x97uMSFxWv6x/views/gv_FMcMHrkan98Z
Channeled
APP
·
·
💤 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!
David Kreiger
·
·
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
Bruno (Clay)
·
·
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!
Channeled
APP
·
·
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!
Channeled
APP
·
·
Hi David Kreiger! This thread was recently closed by our Support team. If you have a moment, please share your feedback: