Drop Down List assigning a score

Clayton DSouza
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.

image.png


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!