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.


  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


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!