Sum dropdown list with unique values associated with text?

mkeeling

Hi there,

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?

Thanks,

Matt

Hollie Green

You could probably use an IF(CONTAINS( formula you would probably have to add them together

Example

=SUM(IF(CONTAINS("apple", [Code B]1), 5), IF(CONTAINS("Banana", [Code B]1), 3))

This will give the apple a value of 5 and the banana a value of 3 since they both occur in my code B cell it returns the value of 8

mkeeling

Thanks - I had tried something similar but think I wonked up the bracket placement. Much appreciated!