Drop Down List assigning a score
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
Check out the Formula Handbook template!