Why is it not counting "MTS" in my sheet summary

If you see in the PROJECTS column there are multiple entries. "MTS" is one of those options, but it made me realize its not counting it if there are multiple entries. Here is my formula:

=COUNTIFS(Projects:Projects, "MTS")

How do I get it to see the MTS in the PROJECTS column?

Ricky T

Gov Contractor for USSF

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!