$ Formatting not rolling up in Report Summary / Dashboard

I have a report that is has a summary of US$ formatted amounts, however the summary amount only shows a number; it doesn't inherit the US$ formatting and there is no means to change it. When this summary data is presented in a dashboard it presents as a number as a opposed to US$ amount there too.

Any idea how I can get the report to apply the US$ format to the summary data?

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!