Sum dropdown list with unique values associated with text?
I'm building a QA form where the QA users can select multiple radio buttons in different sections such as below:
We'd like each of the radio buttons to carry a specific score, and I'd like the Smartsheet file to then be able to total up the score based on the individual selections. Is there a specific formula I could write to sum up the totals based on the text, assigning each option a unique value?
Help Article Resources
Check out the Formula Handbook template!