Create formula to prepopulate cSAT Numeric column based on response to "cSAT":
Create formula to prepopulate 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, "")))))
