Current Month & Previous Months Cumulative Net Promoter Score (NPS) Report & Dashboard
Hello SS Community.
I have a Smartsheet that collects NPS scores by branch. The branch field is a multi-select field and the total NPS score is calculated based on the (number of promoters - number of detractors)/total number of scores. Neutral scores are tabulated in the denominator but not the numerator.
What I would like to do is be able to create a report and then a dashboard that calculates the cumulative NPS by branch as of the previous month and then the cumulative score as of the current month so we can see the trend over time how scores are changing and improving.
I'm new to Smartsheets and am trying to figure out the best way to complete this task.
I have team members helping me and we already have a helper column that determines whether a score indicates a Promoter (9 & 10), Neutral (7 & 8) or Detractor (6 and below).
We also have created sheet summary definitions for each branch and their promoter, neutral and detractor scores and tabulated the NPS scores by branch into a report.
We are now trying add an additional report and dashboard that reports the cumulative NPS by branch as of a point in time - as of the current month and as of the previous month.
The additional challenge that we are mentally trying to overcome is that we already have used up over 150 of our sheet summary calculations due to the number of branches that we have so we are trying to figure out how to get around that as well. We have almost 50 branches that we are reporting on.
I have attached some screenshots below which may be of help to better explain the above.
Any assistance you can provide would be greatly appreciated.
Answers
-
Not yet sure exactly how or if these helper columns will help me but I have researched the forum and figured out how to automatically calculate if the review is in the current month or in a previous month
-
Thank you to anyone that responded with an answer. I figured out how to do it.
-
Excellent!
Glad you got it working!
✅Please support the Community by marking your post with the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
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.
-
Thank you!
-
You're more than welcome!
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.9K Get Help
- 378 Global Discussions
- 208 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 296 Events
- 33 Webinars
- 7.3K Forum Archives