Sum Formula for Adding Values
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)))))))
Answers
-
Here is the dropdown. Not all options in the dropdown will have a value, just trying to get the formula to work for the options that will have a value. If I build in the Medical, Dental, Vision and the Spending Accounts (FSA, HSA, etc) options into the formula it will work fine. However if I build in a third option such as Basic Life and Disability, it breaks the formula. Not sure what I am doing wrong.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 140 Industry Talk
- 472 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!