Sum of values from a Multi-select Dropdown list

Platform discussions Special workflows & use cases
,
1

I’m trying to generate a sum based on multiple selections from a dropdown list. This is the formula that I’ve put together, and it works when only one item is selected from the dropdown, but when more than one item from the dropdown list is selected it returns 0 for the Sum.

3000 +
SUM(
(IF({Options} = “Stairs”, 40)),
(IF({Options} = “Railings”, 30)),
(IF({Options} = “Frames”, 20)),
(IF({Options} = “Baseboards”, 10))
)

Any help would be greatly appreciated.

2

Hi Jeffrey,

Here is one way of doing it.

To check if an item is in the column, you use:

SEARCH("Stairs",{Options#Labels})

If the result is 0, then it is not in the column. If it is higher than 0, it is (no matter the position).

So your formula should be:

IF(SEARCH("Stairs",{Dropdown#Labels})>0,40,0) + 
IF(SEARCH("Railings",{Dropdown#Labels})>0,30,0) + 
IF(SEARCH("Frames",{Dropdown#Labels})>0,20,0) + 
IF(SEARCH("Baseboards",{Dropdown#Labels})>0,10,0)

Looking for a simpler way to write complex formulas? Check out the Advanced Formula Booster at https://mdboosters.com. It’s a convenient third-party app that simplifies formula writing. With it, you can spread your formulas across several lines, utilize variables, and access dozens of functions not found in the standard formula column.

3

That worked perfectly, thank you very much for the help!