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

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!