Percentage Difference

Options
kjoseph87
kjoseph87 ✭
edited 12/09/19 in Smartsheet Basics

Hi Community,

I'm working on creating a very intuitive dashboard and I need to calculate the percentage between two different months. How do I calculate it in Smart sheet?

 

For example, let's say the total for May is 352,000 and the total for June is 226,000 how can I calculate the percentage difference between May and June?

 

· Share on FacebookShare on Twitter

Comments

  • Andrée Starå
    Andrée Starå ✭✭✭✭✭✭
    Options

    Hi,

    Is everything coming from the same sheet? You could either calculate the percentage on the sheet or another that I call, Master Metric Sheet.

    My preferred method is the Master Metric Sheet because it makes it easy to collect and calculate everything in one place.

    Would any of those options work for you?

    Have a fantastic weekend!

    Best,

    Andrée Starå

    Workflow Consultant @ Get Done Consulting

    SMARTSHEET EXPERT CONSULTANT & PARTNER

    Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

    W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35

    Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.

    · Share on FacebookShare on Twitter

Categories

Help shape the future of Smartsheet.
Share your ideas and feature requests.

 Watch video