Summed values no longer having commas

Options

Starting this week, I noticed all my summed pricing values in reports no longer have commas - has anyone else experienced this and is there a fix?

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Laura25

    This is an issue that was reported to our Support team and we're currently looking into it, however I don't have an ETA for when this may be updated.

    In the meantime, it may help if you go into the source columns and adjust the formatting for the entire column to a plain number format, then adjust it back to have the thousands format - this can sometimes help "refresh" the Report to display the summary values with the formatting applied.

    Cheers,

    Genevieve

  • Laura25
    Laura25 ✭✭
    Options

    Thanks for the response Genevieve! Unfortunately my report pulls from over 140 individual sheets so that would be a bit of a challenge to do that - but I did test it with a few sheets to see if would fix the summary just from those and it still isn't working. Hope you can find a resolution soon!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!