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
- Smartsheet Customer Resources
- 63.6K Get Help
- 405 Global Discussions
- 215 Industry Talk
- 456 Announcements
- 4.7K Ideas & Feature Requests
- 141 Brandfolder
- 136 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 297 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!