Percentage Difference
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?
Comments
-
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.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.4K Get Help
- 364 Global Discussions
- 200 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives