I am trying to create a formula where it is looking at a column with a dropdown where multiple options can be selected and assigning a value to each option that may be selected. I thought that I had the formula set up correctly but keep getting the error #UNPARSEABLE.
Can someone help me understand what I might be doing wrong with the formula? When I do two IF options, it works but when I add any more than that, it seems to break.
=SUM(IF(CONTAINS("Medical, Dental, Vision", [Carrier Changing for which Benefits?]@row), 3),
(IF(CONTAINS("Spending Accounts (FSA, HSA, etc)", [Carrier Changing for which Benefits?]@row), 3),
(IF(CONTAINS("Basic Life and Disability", [Carrier Changing for which Benefits?]@row), 2),
(IF(CONTAINS("Voluntary Life and Disability", [Carrier Changing for which Benefits?]@row), 2),
(IF(CONTAINS("Critical Illness", [Carrier Changing for which Benefits?]@row), 1),
(IF(CONTAINS("Accidental Insurance", [Carrier Changing for which Benefits?]@row), 1),
(IF(CONTAINS("Other", [Carrier Changing for which Benefits?]@row), 1)))))))