Dashboard isnt picking values with K or M

Hi, I have a revenue data set in millions and thousands. I am able to convert them to K and M unit using formulae.

Now the irony is that this cannot be charted on the dashboard.

I wish to display the bar chart with value as 5.9M or 790K but the dashboard isnt working.

Any workaround. Please suggest.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!