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
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending in Smartsheet Basics
- Can I link a Smartsheet report in a form. My form will be for a person to confirm info from a report is correct. So I want the user to be able to view the report while filling out the form.
- I have 4 sheets used by individuals to track their work. I have a report that pulls from all 4 of those sheets to give me a total count of items they listed for the month as well as each line item (de…
- Hi All! Quick question - I am working on a form with a lot of yes or no questions, and I decided to display them as horizontal radio buttons. They are all circles except for one question, which shows …
