I'm trying to do some automated scoring based on the values of a Choice field.
The user can select more than one value. I need to SUM all the points for the various choices made by the user.
Column name is Project
Choice values are Widgets1, Widgets2 and Widgets3
The scoring is based on the choice of widgets:
Widgets1 is 10 points
Widgets2 is 25 points
Widgets3 is 50 points
If Widgets1 and Widgets3 are selected, the score is 60
If Widgets2 and Widgets3 are selected, the score is 75 and so on...
Struggling with syntax on this one. Any help would be most appreciated.
(Thanks @mike-smith-mct-mvp for helping me with a similar post previously)