Multi Select Dropdown, Adding Values

Options

I created a column with a multi-select dropdown. I would like to add values for each selection and then create a formula to add the values together.

Example:

Column Name: Findings

Multi-Select Options: Subawards, Effort, Late Charges, Reporting

If someone selected Effort, Late Charges and Reporting, I would like the next column, Findings Risk Score to give each of those selections a value and then add the values together. I'm not sure yet if each selection will have the same value or if the values are weighted, so I would love to hear solutions for each.

I have used the IF statement to give each selection a value, but I've only used that in singe-select dropdowns.

Thanks so much!

Best Answer

  • Leibel S
    Leibel S ✭✭✭✭✭✭
    Answer ✓
    Options

    @Jessyo

    You can use the HAS function and keep on adding as many IF (preceded with a + sign) functions you need. See below example:


    =IF(HAS([Findings]@row, "Effort"), 5) + IF(HAS([Findings]@row, "Reporting"), 7)

Answers