Is there a way to use a countif formula if the cell reference is a formula as well?
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)
Tags:
Comments
-
Ivan -
Can you provide a screenshot? I mocked this up and the formula is working fine using what you had provided.Sean
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!