How can I remove decimal places for Summarized columns in a report?

Kathy PPT

Hi,

The two circled columns are generated via the Summarize>Average function in this report. As suggested, I checked the source report and there are no decimal points. I have no way to format the Average function (i.e.: using Round, etc.). Any thoughts please?

Georgie

Hi @Kathy PPT,

Having tested this, when my source sheet contained no decimals, the AVG summary in the report did not show decimals. I found this related thread which suggests an alternative solution of increasing the decimals in the source sheet and then reverting it back to show no decimals, resulting in the report showing no decimals in the summary rows:

• How do I stop my report from generating numbers to the 4th decimal?

However, there’s currently no way within a report to increase or decrease the number of decimals that a report summary shows - as @Melissa Yamada suggested, you can submit a product idea for this. The best way to do this is to create an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!

You can also review these related threads:  

• Can you change the number of decimal places in a report's "Total" field for averages?
• Unable to increase/decrease decimals in Sheet Summary Report (using AVG summary)

Hope that helps!

Georgie

Kerry Odell

Is this a regular report or a summary report? You may need to check the formatting in the summary area of the source sheet. On the right side, click the summary icon.

Then click the 3 dots next to the summary item you want to format.

Then choose your formatting from the menu.

Kathy PPT

Hi @Kerry Odell,

Thanks for the info. However, this is a regular report that uses the Intake Sheet as the source.

Melissa Yamada

Hello @Kathy PPT

I don't think there is a current feature for that right now. It would be a great addition to Smartsheet features.

You can submit the request here:

https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409&_gl=1k1wu2a_gcl_auMTkwNTg0MzEyNi4xNzM2MzM1NzAw_gaNzIwNjM3MzM1LjE3MzYzMzU3MDA._ga_ZYH7XNXMZK*MTczNjQwMjU1NC41LjEuMTczNjQwNjUyMy41OS4wLjA.

Georgie

Hi @Kathy PPT,

Having tested this, when my source sheet contained no decimals, the AVG summary in the report did not show decimals. I found this related thread which suggests an alternative solution of increasing the decimals in the source sheet and then reverting it back to show no decimals, resulting in the report showing no decimals in the summary rows:

• How do I stop my report from generating numbers to the 4th decimal?

However, there’s currently no way within a report to increase or decrease the number of decimals that a report summary shows - as @Melissa Yamada suggested, you can submit a product idea for this. The best way to do this is to create an Idea Post in the Smartsheet Product Feedback and Ideas topic here in the Community. This will allow other users to vote on your enhancement idea!

You can also review these related threads:  

• Can you change the number of decimal places in a report's "Total" field for averages?
• Unable to increase/decrease decimals in Sheet Summary Report (using AVG summary)

Hope that helps!

Georgie

Kathy PPT

Melissa, Georgie, Thanks for feedback!

@Georgie

An enhancement request was submitted by Paris.TechProjSpecialist in

https://community.smartsheet.com/discussion/106719/unable-to-increase-decrease-decimals-in-sheet-summary-report-using-avg-summary#latest

How do I find that so I can add to it and see what the status of the request is? Searching for it in Smartsheet Product Feedback & Ideas simply takes me back to the post in Community.

Genevieve P.

Hi @Kathy PPT

Just jumping in here to note that it looks like Paris.TechProjSpecialist submitted it as a private message to the Product Team in the Feedback Form (versus a public idea in the Community). This is the Form Melissa linked above.

Here's the related idea that you can vote on:
Report Summary and Grouping: add custom formatting

Cheers,
Genevieve