Shorten numbers & format to display thousands as "K" , millions as"M" but still remain as numbers
I'd like to ask your help regarding a task I'm trying to complete on Smartsheet. I'm trying to shorten the numbers in a table show thousands with "K" and millions with "M" after the first comma instead of showing the entire number. I found the thread below and it gave me the rounding and formatting results. However, there's also another requirement. I have to show the numbers in chart on a dashboard. The issue I have now is that the chart is not showing the values because they are no longer "numbers".
Is there a way to apply the rounding and formatting but keep the resulting value as a "number" so that the chart can pick them up?
Hope you could share your inputs.
Help Article Resources
Check out the Formula Handbook template!