Is there a way to use a countif formula if the cell reference is a formula as well?

Ivan Bowskill
Ivan Bowskill ✭✭
edited 12/09/19 in Formulas and Functions

Hi All,

Any help would be appreciated.

I get #NO MATCH when I run the below formula. Is it an issue with a formula referencing a formula?


="Not Completed: " + COUNTIF([Column3]2:[Column3]24, FIND("Not Completed", @cell) > 0)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!