Graphing / Rounding / Millions

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

  • Ric T
    Ric T ✭✭✭✭✭

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!