Create formula to pre-populate cSAT Numeric column based on response to "cSAT":
Create formula to pre-populate cSAT Numeric column based on response to "cSAT":
- Extremely Satisfied = 5
- Somewhat Satisfied = 4
- Neither Satisfied or Dissatisfied = 3
- Somewhat Dissatisfied = 2
- Extremely Dissatisfied = 1
Answers
-
Hi @Khadija Ali,
Try this!
=IF([cSAT Response]@row = "Extremely Satisfied", 5, IF([cSAT Response]@row = "Somewhat Satisfied", 4, IF([cSAT Response]@row = "Neither Satisfied or Dissatisfied", 3, IF([cSAT Response]@row = "Somewhat Dissatisfied", 2, IF([cSAT Response]@row = "Extremely Dissatisfied", 1, "")))))
BRgds,
-Ray -
I am not sure why I am getting Unparsable error. I am not sure what is not working in the formula. Here is a snippet of the sheet columns I am using:
-
You would need to either:
1.) edit the formula to reflect your actual column names.
or
2.) change your column names to the names in the solution I recommended.
Here's what the formula would look like for option 1:
=IF([cSAT]@row = "Extremely Satisfied", 5, IF([cSAT]@row = "Somewhat Satisfied", 4, IF([cSAT]@row = "Neither Satisfied or Dissatisfied", 3, IF([cSAT]@row = "Somewhat Dissatisfied", 2, IF([cSAT]@row = "Extremely Dissatisfied", 1, "")))))
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives