Multi Select Dropdown, Adding Values

Jessyo

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!

Leibel S

@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)

Leibel S

@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)

Jessyo

@Leibel Shuchat

Thank you so much! That is exactly what I needed!