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
- Smartsheet Customer Resources
- 63.4K Get Help
- 396 Global Discussions
- 213 Industry Talk
- 448 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 133 Just for fun
- 56 Community Job Board
- 454 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 293 Events
- 35 Webinars
- 7.3K Forum Archives