How to calculate NPS Score from Smartsheet Sheet
Hello,
I have tried to calculate our NPS score, but am getting either UNPARSEABLE or 0. What am I doing wrong here?
I've tried this formula (NPS Score 1):
And this one (NPS Score 2):
Best Answer
-
Thanks Darren,
I've just realised that for some reason the main problem was that the rows didn't consistently have content in them. As soon as i filled in the blanks, the NPS result came to life.
Based on that, it looks like you can still keep the " " in.
Appreciate your help, thank you
P.S. NPS Score 2 worked - NPS Score 1 is still UNPARSEABLE.
Answers
-
@GWOOD02 since you are using numerical values as your criteria don't put them in quotes just use <7 not "<7" same for your other criterion for >8.
Darren Mullen, join the Smartsheet Guru Elite
Get my 7 Smartsheet tips here
Author of: Smartsheet Architecture Solutions
-
Thanks Darren,
I've just realised that for some reason the main problem was that the rows didn't consistently have content in them. As soon as i filled in the blanks, the NPS result came to life.
Based on that, it looks like you can still keep the " " in.
Appreciate your help, thank you
P.S. NPS Score 2 worked - NPS Score 1 is still UNPARSEABLE.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.1K Get Help
- 430 Global Discussions
- 149 Industry Talk
- 490 Announcements
- 5.2K Ideas & Feature Requests
- 85 Brandfolder
- 154 Just for fun
- 74 Community Job Board
- 499 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!