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

Michael Yohe

这是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?

Toufong Vang

Hi, Michael.

You can use theROUND()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

Hi, Michael.<\/p>

You can use the ROUND()<\/strong> function for this.<\/p>

= ROUND(<\/strong> your_current_formula<\/em> <\/em>, 2)<\/strong><\/p>

You'll find documentation for this function, and others, here, https:\/\/help.smartsheet.com\/functions<\/a><\/p>","bodyRaw":"[{\"insert\":\"Hi, Michael.\\nYou can use the\"},{\"attributes\":{\"bold\":true},\"insert\":\" ROUND()\"},{\"insert\":\" function for this.\\n \"},{\"attributes\":{\"bold\":true},\"insert\":\"= ROUND(\"},{\"insert\":\" \"},{\"attributes\":{\"italic\":true},\"insert\":\"your_current_formula\"},{\"attributes\":{\"italic\":true,\"bold\":true},\"insert\":\" \"},{\"attributes\":{\"bold\":true},\"insert\":\", 2)\"},{\"insert\":\"\\nYou'll find documentation for this function, and others, here, \"},{\"attributes\":{\"link\":\"https:\\\/\\\/help.smartsheet.com\\\/functions\"},\"insert\":\"https:\\\/\\\/help.smartsheet.com\\\/functions\"},{\"insert\":\"\\n\"}]","format":"rich","dateInserted":"2021-06-14T23:07:50+00:00","insertUser":{"userID":136737,"name":"Toufong Vang","title":"","url":"https:\/\/community.smartsheet.com\/profile\/Toufong%20Vang","photoUrl":"https:\/\/us.v-cdn.net\/6031209\/uploads\/avatarstock\/n65S9PRP4PA0M.png","dateLastActive":"2023-06-28T16:10:01+00:00","banned":0,"punished":0,"private":false,"label":"✭✭✭✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/294901#Comment_294901","embedType":"quote"}"> 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.

需要澄清的是,表中的数字是基于“增大化现实”技术e 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

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

I have the same question. I would like to change the decimal length on reports. Has it been determined if this is possible?<\/p>","bodyRaw":"[{\"insert\":\"I have the same question. I would like to change the decimal length on reports. Has it been determined if this is possible? \\n\"}]","format":"rich","dateInserted":"2022-03-03T18:54:33+00:00","insertUser":{"userID":128054,"name":"Jessica Bailey","url":"https:\/\/community.smartsheet.com\/profile\/Jessica%20Bailey","photoUrl":"https:\/\/aws.smartsheet.com\/storageProxy\/image\/images\/u!1!WutCn2b6WXQ!ZHdDGcKNYro!ckrEBKaSMuD","dateLastActive":"2022-08-15T20:37:34+00:00","banned":0,"punished":0,"private":false,"label":"✭✭"},"displayOptions":{"showUserLabel":false,"showCompactUserInfo":true,"showDiscussionLink":false,"showPostLink":false,"showCategoryLink":false,"renderFullContent":false,"expandByDefault":false},"url":"https:\/\/community.smartsheet.com\/discussion\/comment\/321449#Comment_321449","embedType":"quote"}"> https://community.smartsheet.com/discussion/comment/321449#Comment_321449

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

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

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

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

EHatch

Same issue here. I need to be able to change the decimal length in summaries on reports without having to add functions to multiple fields across multiple sheets.

马克B。

Same issue. Not only support for ROUND(), reports should also allow other basic formatting functions without having to jump through hoops with helper columns.

Paul Souliere

I agree Smartsheet needs better formatting capabilities especially in reports.

LibbyJ

Same issue here, it is particularly challenging to have these unnecessarily longer numbers included on reports and dashboards

Morris R

I agree , having the same issue

Has this been reported? (I assume so)

Thank you

Morris R

Morris R

https://community.smartsheet.com/discussion/93009/how-do-i-stop-my-report-from-generating-numbers-to-the-4th-decimal?_gl=1*1acv487*_ga*OTE0NzI5MzA5LjE2NjA2Nzc1OTA.*_ga_ZYH7XNXMZK*MTY2NzI0Mzk2Ny4xMTcuMS4xNjY3MjQ1NDQ0LjQuMC4w

Moxam

I have a similar question. I have a sheet that shows forecast dollars by year. The numbers on the sheet are rounded to the nearest dollar. I would like to show the forecast values on a report, but in 1,000's. Is there a way to format numbers on a report without having to rely on the formatting on the source sheet? The only other option I can think of, is to create dummy columns, and divide the original values by 1000 to achieve the desired format (but this adds several columns to an already large master sheet.

I appreciate any thoughts/advice on this matter.