Seeking a formula that counts specific characters in a cell.

My project task sheet has parent rows for each department and child row for each project within the parent department. Each project row has a LEAD DEPT column with dropdown options that show the department acronym and business unit---DEPARTMENT (Unit).

The LEAD DEPT options are;

  • DCM (Marketing)
  • DCM (Membership)
  • DCM (Publications)

I am trying to create a "COUNTIF" formula that will count the total number of rows where the LEAD DEPT includes the acronym "DCM" and ignores the units. Using the options above, I want a formula that returns a value of "3".


Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!