COUNTIF with specific text

Taylor S

Hello,

I am trying to do a COUNTIF formula that counts the number of cells that have the "gap" in the text. My current formula works but I would like to modify it to count cells that just contain the word "gap" and does not account for capitalization (I.E. can pick up on "gap", "GAP", "Gap" etc. . How can I include that?

Current formula: COUNTIF(Range), FIND("gap", @cell)>0)

thanks!

Paul Newcome

Try a CONTAINS function instead.

https://help.smartsheet.com/function/contains