Dollar Sign Not Showing in Metric Sheet

Hi Everyone!

I'm not great with formulas, and I was hoping someone might be able to help me figure out what I'm missing. I have a column in a sheet that contains dollar amounts. I then have a separate metrics sheet where that column totals (to be pulled into a dashboard), however even though the source sheet contains dollar signs and commas, they are not reflected in the metrics sheet.

Ex: Source sheet: $123,456.78

Metrics sheet: 123456.78

I am using just a simple SUM formula to total the column. Is there an easy way to fix this so the correct currency format is pulled in?

Thanks!!

Find more posts tagged with

Accepted answers

All comments

Genevieve P.

Hi @Kate Gallo

It sounds like you just need to turn on currency formatting for that column in your metric sheet. Click on the column name to highlight it, then choose your preferred currency format from the toolbar in the top menu:

Screen Shot 2021-09-24 at 9.06.53 PM.png

See: Formatting Options

Cheers!

Genevieve

Kate Gallo

Hi @Genevieve P. !

Oh my GOODNESS. 🤦 I figured it was going to be something easy, but I can't believe it was THAT easy, and that I completely missed such an obvious option!

That totally worked. Thank you so much! ⭐️

Genevieve P.

Haha no problem at all! I'm so glad it was an easy fix.

Have a great weekend! 🙂

Tammy Tice

@Genevieve P. I have a similar issue. I have currency labels showing in the chart, however, the currency format does not show on the Y axis lab. Is there a way to fix that? Is it because I have 2 sets of data, one currency and one numerical?

I find charting in Smartsheet has limited control over the appearance and format of charts. There really needs to be more control. For instance my dollar amounts and numbers in the chart are way too big.

Genevieve P.

Hi @Tammy Tice

You're correct - the Y Axis is only showing numerical because your data has a mixture of $ values and plain number values. If you updated the data that say 79 and 22 to be $79 and $22, your Y Axis should automatically update to show a $ sign in front of the numbers as well.

Please feel free to add your suggestions and vote to this Product Idea: Editable Font Size and Colour for Data Labels on Charts!

Thanks,

Genevieve

Tammy Tice

Thanks a bunch for confirming that is why the $ does not show on the Y axis. Even though there is no legend, we know what the small numbers are quantity and the larger numbers are $. I just wish I could make those large numbers have a dollar sign to look better. I also wish there was a combination chart type to allow a secondary axis like this occurrence to be charted.

Brett123

I have a similar issue in that if I pull the same data from a sheet, the chart shows the correct currency format $1,000,000 for instance. If I take the data and summarize it in a report and then chart it, it won't display the comma or $, only 1000000

Anything I am doing wrong? Please help

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.