Can you change the number of decimal places in a report's "Total" field for averages?

Michael Yohe
Michael Yohe ✭
edited 06/14/21 in Smartsheet Basics

This is a report that is populated by a few sheets and is used to average the columns.

Look below and notice how the Avg for the manager has only 2 decimal places. However, the "Total" has 6. Can we make Total have 2 decimal places like the manager line?

Screenshot_1.jpg


Tags:

Answers

  • Toufong Vang
    Toufong Vang ✭✭✭✭

    Hi, Michael.

    You can use the ROUND() function for this.

    = ROUND( your_current_formula , 2)

    You'll find documentation for this function, and others, here, https://help.smartsheet.com/functions

  • Michael Yohe
    Michael Yohe ✭
    edited 06/15/21
    https://community.smartsheet.com/discussion/comment/294901#Comment_294901

    Thanks for answering my question. Unfortunately, this is in a report, not a sheet. It seems that reports do not allow you do do...well...anything at all. I can't find how to add or edit any information, including formulas.

    To be clear, the numbers are in the sheet which are then pulled into the report and averaged inside the report. I suppose I could manually do this by averaging them (with a ROUND) inside the sheet myself and then pulling those lines in. I was just hoping that I could do this more cleanly by simply pulling the data into the report. I like how it had a nice drop-down for each manager and looked pretty clean.

  • Jessica Bailey
    Jessica Bailey ✭✭✭✭✭✭

    I have the same question. I would like to change the decimal length on reports. Has it been determined if this is possible?

  • Paula Meunier
    Paula Meunier ✭✭✭✭✭
    https://community.smartsheet.com/discussion/comment/321449#Comment_321449

    I've had success by reducing the decimals in the reference source sheet.

  • Jumana Bowes
    Jumana Bowes ✭

    I'm also looking to do the same. Haven't had any success yet. I can get it to work the way I want by reducing decimals in the reference source sheet (as Paula suggested) but then it reverts back. Not sure what I need to do to get it to stick. Any ideas?

  • Denny Lawrence
    Denny Lawrence ✭

    Just checking in to see if there have been any solutions to this issue. My source grid is formatted properly (I'm using currency $ w/0 decimals) but the report in my dashboard is showing 2 #'s after the decimal point.

  • Susan Morash
    Susan Morash ✭✭✭✭✭✭

    Adding my name here as I would love to see rounding capability in Smartsheet reports.

Categories