Applying complex formula to Column
Good day gurus,
I need to apply multiple IF statements to a Column. Based on the choice made from a drop down menu, the result will return a number. The statement below works; however is not in the correct syntax for applying it to an entire column. I tried to use @Row but I am failing miserable as all my attempts are resulting in #UNPARSEABLE return. Any assistance would be great!
=IF(DROPDOWN1 = "Very unlikely", 1, IF(DROPDOWN1 ="Unlikely", 2, IF(DROPDOWN1 ="Possible", 4, IF(DROPDOWN1 ="Likely", 8, IF(DROPDOWN1 = "Very likely", 16, "")))))
"NOTE: SmartSheet auto formats the field and removes the brackets [ ]. My goal is to automatically apply it to all new records in the sheet.
Help Article Resources
Check out the Formula Handbook template!