I want to use a Google Sheets formula to correct a multiple choice survey that I built using Squarespace. The results get dumped into Google sheets.
For example, if the respondent selects choice:
I tried to string several Regexmatch statements together such as the below but it won't work for more than one regexmatch at a time:
=if(regexmatch(A2, "A."), 0,) (regexmatch(A2, "B."), 1,) (regexmatch(A2, "C."), 2,)
Any advice would be appreciated. Thanks!