Hello Community -
Is there a way to format reports so that it shows only 0, 1 or 2 decimal points v 3, 4 or 5? I am using a few reports on some dashboards, but the decimal places are a bit distracting and kind of an eye sore. Any advice is greatly appreciated!
You can do this by formatting the sheet you're pulling the information from for the report. Select the cells or columns that contain the numbers you'd like to round & then use the following buttons to control how many decimals display:
The left button will reduce the number of decimals & the right button will increase them. Hope this helps! 😊
✅ Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. This will make it easier for others to find a solution or help to answer!
Hi @ro.fei - this is on a REPORT, not a sheet. The sheet has all whole numbers, but the average function on the REPORT is the problem.
@Dawn_ATX Apologies, I didn't realize you were talking solely about summary rows in reports. Unfortunately, I don't believe there's a way to change the decimals displayed in summary rows on reports.
A way I've found to work around this in the past is to create a separate metrics sheet & calculate the summary rows myself using formulas--then I pull the metric from the metrics sheet to display on my dashboard. That way you have the information in a sheet, giving you more control over the formatting.
If you're trying to calculate the average of a column, select the whole column in your sheet reference inside of the AVG function. Let me know if this works for you, I'm happy to provide more direction if you run into any issues 😊
Hi @ro.fei - thanks for that. I ended up creating a bunch of sheets that I could modify the decimal places, which worked. It's just easier (and cleaner) to use reports, but using sheets is the workaround for now. Thanks!
@Dawn_ATX Glad I could help! I'm hoping they let us format reports sometime in the future. I've submitted an idea on here for it, it just needs enough votes so hopefully they see it's something we want
I've been trying to do a simple check of whether or not the entry from the form has a returned value that is either yes or no and it checks 3 cell locations to see if any returned yes. The 3 columns are Dropdown lists for Yes/No and the Status is a Text/Number, is that the issues? If not how do i fix that?
I'm wondering if there is a way to lock rows 1-12 out of the sorting and filtering of a sheet. I might have take out that part of the from otherwise I dont like how the built in dashboard moves when a sort or filter is applied?
Hello, I apologize if this has already been answered, I did search before asking. I recently downloaded a template and it had the google slides displayed in presentation mode. I cannot figure out how to do this as when I embed, it's just the entire google page where you can edit and see the menu bar. How do I embed the…
Help shape the future of Smartsheet.
Share your ideas and feature requests.
©2023. All Rights Reserved Smartsheet Inc.