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.

Find more posts tagged with

Accepted answers

All comments

parulmishra

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

HCarullo

Hi @HSabin have you fixed it? If so, could you share how you did it? We have the same issue.

HSabin

Hi @parulmishra - thank you for the tip. I did check and both are formatted correctly. I'm really struggling to figure this one out.

RetroCare

I am having the exact same issue, it just happened today. Smartsheets please fix this ASAP!!!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.