Does the COUNTIF Function work if the criterion have decimal places?

I am working on an extended process and I want to sub-categorize a set of steps. Ideally I want to use the 1.1, 1.2, 1.1.1 as step headers but when I try and do functions to count cells it is not working.


Example:

The COUNTIF functions work for the whole numbered entries but will not pull with the decimal entries. Here are the two formulas I am using:


Good formula:

=COUNTIF([Current Pipeline Stage]:[Current Pipeline Stage], "3 engaged")


Broken formula:

=COUNTIF([Current Pipeline Stage]:[Current Pipeline Stage], "4.1 Drafting")


Any suggestions on how I can get those formulas happy again?


Thanks!

Lex

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!