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.


Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!