Sum dropdown list with unique values associated with text?

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

Answers

  • Hollie Green
    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

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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!