STUMPED: How to include US Dollar Sign in Report using SUM summaries
I have been working on testing out some reporting and dashboards. In a proof of concept report I built, I was able to add 2 summaries for Count and SUM. This report included the "$" in the summary (see pic 1).
However, when I built out the 2nd report (using a copy of the first) I am unable to replicate it so the "$" shows in the summary parent lines of the report. (See pic 2)
Does anyone have any ideas how to fix this? I'm stumped.
Answers
-
Hi @HSabin
Try checking the formatting of the Summary column in both the sheets you are referencing in the report.
If even one cell in the referenced column doesn't have the correct formatting applied, then the Report will default to the numbers. However if entire column has Currency and Thousand formatting, you should see it accurately on the Sum as well
Parul Mishra
-
Hi @HSabin have you fixed it? If so, could you share how you did it? We have the same issue.
-
Hi @parulmishra - thank you for the tip. I did check and both are formatted correctly. I'm really struggling to figure this one out.
-
I am having the exact same issue, it just happened today. Smartsheets please fix this ASAP!!!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives