Graphing / Rounding / Millions
Susan Swisher
✭✭✭✭✭
Can I recreate this GRAPH / Dashboard
The numbers are defaulted to Millions; they are presented in our sheets as $5,100,000 and $3,180,000, respectively; however, for ease of visualization, we want to round them and graph them as shown.
HELP!
Tags:
Answers

Hi @Susan Swisher,
All good! Next to your columns where you have $5,100,000 and $3,180,000, you'll need to create a formula in another cell (helper column) that looks like:
=[Name of your column here]@row / 1000000
This gives you your desired output (screenshot below), then in your dashboard chart, highlight the column that you want to generate. Keep in mind that if you want everything to be 2 decimal points, you might need to increase decimal points (main toolbar) in your sheet.
Cheers,
Ric
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!