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.


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?




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!