I am fairly new to working with formulas. I have a Project Status column that contains several values with "In Progress". For example, In Progress - Scoping, In Progress - Development, etc.

I would like to count all the instances of any variation of In Progress. I have tried working with HAS and CONTAINS and recently came across FIND. I just can't seem to get the syntax correct.

This is where i left off!! I would appreciate any help.

=COUNTIFS([Project Status NEW]:[Project Status NEW], FIND("In Progress",[Project Status NEW]))

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!