Round Function Freaks Out
I'm using the Round formula to reduce the amount of numbers in a total amount and then push it to a dashboard. See below:
Total Value: $14,973,331
=(ROUND([Column34]3, -5)) / 1000000
While the formula does indeed work, sometimes Smartsheet has a total freak out moment and displays the incorrect value. This gets pushed to my dashboard which is how I usually know when it's happening. Attaching an image to show how it's displayed (it may be old data so numbers don't match exactly).
Oddly, I go into my formula sheet, Smartsheet does this weird refresh thing and then asks me to save. Once I save the formula sheet and refresh the dashboard, everything's normal again.
Does anyone know why Smartsheet might be having an "episode" and asking me to Save as soon as I enter the sheet? And why does it sometimes incorrectly display this total amount using this formula?
Happy to answer any questions you might have. I've been trying to capture a screenshot of the formula sheet displaying incorrectly but Smartsheet is too fast for me!
Help Article Resources
Check out the Formula Handbook template!