How to find specific text within a string, in a COUNTIFS statement

(This was posted as a question previously, however I am unable to mark that as "unanswered" and am asking this again)

Hi everyone,

I am using a COUNTIFS to search a linked sheet, with one of the conditional IFS to be if the date falls in a specific month, and a specific year.

Example: Condition 1, Condition 2, Condition 3 = Must have "Jan" in referenced dates, Condition 4 = Year must be "2022" in referenced dates

Have tried "*"&"jan"&"*" as both an IF, and as part of a nested FIND statement - both to no success.

A previous posts incorrect answer proposed this:

COUNTIFS(

{Studio Follow-On Projects Status (Prod) Range 1}, Jurisdiction@row,

{Studio Follow-On Projects Status (Prod) Range 2}, <>"DONE",

{Studio Follow-On Projects Status (Prod) Range 2}, <>"CANCELLED",

{Studio Follow-On Projects Status (Prod) Range 4},

IFERROR(MONTH(@cell),0)=4)


Any other tips please?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!