Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Net Promoter Score
I have a survey web form. One of the questions is "likelihood to recommend" with a dropdown list of 0 - 10. I'm trying to build a report from this web form that will automatically calculate the net promoter score (% promoters (9&10s) - % detractors (0-6s)). I know how to build the formulas to calculate these, but I don't know how to build them so that the stats automatically adjust as surveys automatically come in. Can this be done? And if so - how? Any help would be appreciated.
Comments
-
Have you considered calculating based on the entire column range? [likelihood to recommend]:[likelihood to recommend]
-
Ted is correct, you can select an entire column by removing row numbers from the range. This will only inlcude cells with data, so blank cells will not mess up your numbers.
-
Perfect! You guys ROCK!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.1K Get Help
- 414 Global Discussions
- 221 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 461 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives
