How do I generate scores in a column based on drop-down options selected in another column?

Options

Currently, I have the below dropdowns:

  • PX resources ready
  • CoE resources ready
  • SOP ready
  • NA

In another column, I want to pull in the following scores:

  • If "PX resources ready" is selected = 1
  • If "CoE resources ready" is selected = 1
  • If "SOP ready" is selected = 1
  • If "PX resources ready" and "CoE resources ready" are selected = 2
  • If "PX resources ready" and "SOP ready" are selected = 2
  • If "CoE resources ready" and "SOP ready" are selected = 2
  • If "PX resources ready" and "CoE resources ready" and "SOP ready" are selected = 3
  • If "NA" is selected = 0

How do I get this to work?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!