Customer Survey and NPS Scoring

I have set up of customer survey that includes an NPS question. I am not too familiar with reporting and dashboards yet, so I am having a difficult time envisioning where I should do my NPS calculations ie. Intake sheet, separate sheet, report, etc. This is also my first "solution" build. Currently, I am putting the formulas into the summary sheet to check the formulas and get some high-level metrics.

Where should I be doing my calculations - for adding to a dashboard eventually?
Can someone please confirm these formulas that I currently have set up in my summary sheet? Also, if there is a way to come up with an NPS score with one formula that would be best :) I could not find anything in the community or support section.

a. # of Promoters =COUNTIF([Likeliness to Refer]:[Likeliness to Refer], - this seems to be working

b. # Detractors =COUNTIF([Likeliness to Refer]:[Likeliness to Refer], <=6) - this seems to be working

c. # of Neutrals =COUNTIFS([Likeliness to Refer]:[Likeliness to Refer], =7, [Likeliness to Refer]:[Likeliness to Refer], =8) - THIS IS NOT WORKING - it is returning an incorrect count

Attached is a screenshot of the survey answers on the intake sheet - This is all test data.

Thanks in advance!

Find more posts tagged with

Forms

Sheets

Formulas

Reports

Dashboards

Accepted answers

Sameer Karkhanis

Assuming for neutrals you are looking for those that match 7 or 8, you can use:

=COUNTIF([Likeliness to Refer]:[Likeliness to Refer], OR(@cell=7, @cell=8))

All comments

Sameer Karkhanis

Assuming for neutrals you are looking for those that match 7 or 8, you can use:

=COUNTIF([Likeliness to Refer]:[Likeliness to Refer], OR(@cell=7, @cell=8))

Courtney Collier

@Sameer Karkhanis That worked! Thank you so much!

Kristen Zachwieja

@Courtney Collier would you mind sharing a screenshot of your summary sheet and how you laid that out? Also your a. # of Promoters =COUNTIF([Likeliness to Refer]:[Likeliness to Refer], ...is this supposed to be >=9?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.