I hope you can assist me with this issue i've got.
I have a SharePoint list containing a combination of dropdowns and calculated fields which has been working fine.
Column 1 (Dropdown): ["Option 1", "Option 2", "Option 3" ]
Column 2 (Calculated): If('Column 1' = "Option 1", 5, IF('Column 1' = "Option 2", 4,...)
This worked for single selection dropdowns, but the powers that be, want it to be multiple selections now.
It's a simple fix on the dropdown column, but could I get some help on how to formulate Column 2 to have a specific number per option and then sum it all up at the end.
Thank you for your help in advance.