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

Answers

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

    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

  • Khadija Ali
    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:

  • Ray Lindstrom
    Ray Lindstrom ✭✭✭✭✭✭
    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, "")))))