Multi Select Dropdown, Adding Values
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.
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!