Hello All, Novice Here
I am trying to use a formula that will assign a value based on the words it finds in the table. I am not sure what I am missing. I want the resulting value 1-5 to appear in the "Raw" column. The table below is the mock up of what I am looking to do.
<tbody>
</tbody>
I am trying to use a formula that will assign a value based on the words it finds in the table. I am not sure what I am missing. I want the resulting value 1-5 to appear in the "Raw" column. The table below is the mock up of what I am looking to do.
Code:
=IF([@Answer]="", "",IF([@Answer]"Very Satisfied",5,IF([@Answer]"Satisfied",4,IF([@Answer]"Neither Satisfied Nor Dissatisfied"
,3,IF([@Answer]"Dissatisfied",2,IF([@Answer]"Very Dissatisfied",1,)))))))
Survey Type | Answer | Raw | ||
Post-Chat | Very Satisfied | 5 | ||
<tbody>
</tbody>