# Create formula to pre-populate cSAT Numeric column based on response to "cSAT":

Options

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

• ✭✭✭✭✭✭
edited 07/08/24
Options

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

• Options

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:

• ✭✭✭✭✭✭
edited 07/08/24
Options

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, "")))))

• ✭✭✭✭✭✭
Options