Count formula pulling from multi select

Help! I need a formula that will calculate the total # of times a department is listed within a multi select column.

Scenario:

  1. Sheet "Project Plan" has a "Department(s)" column listing MEQA and Strategic Ops.
  2. Sheet "Status Totals" where I want to build the formula

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!