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.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 146 Just for fun
- 63 Community Job Board
- 465 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives