Dollar Sign Not Showing in Metric Sheet

Kate Gallo

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!!

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:

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! 🙂