Round Function Freaks Out

Nick Allgauer

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

=$15.0

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!

Mark Cronk

Hi @Nick Allgauer ,

Sounds like an updating issue. I haven't encountered anything like it though. You might try adjusting your formula and see if that makes a difference:

=ROUND([Column34]3 / 1000000, -1)

Mark