Round Function Freaks Out

Options

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!


Answers

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Options

    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!