Drop Down List assigning a score

Clayton DSouza
edited 03/20/23 in Formulas and Functions

I am trying to figure out the correct formula to execute an output

I have created a Drop-Down list that the end user can select one or more options.

Each question has an associated score with it (1 or 2). I want the output to generate the overall score and a background color in a separate column. I have it created in excel and want to replicate it to Smartsheet.


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!