Formatting Dashboard Metrics with Commas (,)

zealvert

There are two places where I am unable to format the numbers with commas (,): first, the Sheet Summary; and second, the Dashboard metrics.

It's very difficult for my dashboard visitors to interpret large numbers without commas (e.g., the amount 2320050 would be a lot easier to read as 2,320,050).

Please not that the underlying / source sheets (where the dashboard data are being pulled from) are already formatted with commas; but still they appear without commas in Sheet Summary as well as dashboard metrics.

Please note that due to some database design constraints, I'm bound to pull all the dashboard metrics data — only from the Sheet Summary (and not directly from any sheets).

Any tips please?

Thanks

Darla Brown

Great to hear! 🎉

Naeem Ejaz

You're absolutely right — Smartsheet currently does not support number formatting (like commas for thousands separators) in the Sheet Summary fields or Dashboard metric widgets, even if the source sheet columns are formatted correctly. This is a known limitation and a common frustration among users.

Use a Helper Column with Text Formatting

=TEXT([Your Number Column]@row , "#,###")

• This converts the number into a text string with commas.
• Copy this formatted value manually or via automation into a text-type Sheet Summary field.

Darla Brown

Hi,

Have you formatted your Sheet Summary fields as Numbers and then decreased the decimal? It should pull into the metric with the commas in place.

Thanks

zealvert

Thanks so much @Darla Brown ! It worked!

Darla Brown

Great to hear! 🎉

Paul Newcome

@Naeem Ejaz Please double check your sources. There is no TEXT function in Smartsheet that operates the way you are suggesting.

Naeem Ejaz

@Paul Newcome Yea you are right I will double check the answer in future.