Trying to add a IF date around a countifs statement...

My goal is to only count " =COUNTIFS({ZenQ Testing Required}, FIND([Primary Column]3, @cell) > 0) " if the date is within 2020 year for the created date of the jira ticket.

Can someone help?

Best Answer


  • Ryan Kramer
    Ryan Kramer ✭✭✭✭✭

    Hey @Mark Schlaudraff,

    Be happy to help!

    Should be coming like this -

    =COUNTIFS([ZenQ Testing Required]:[ZenQ Testing Required], ISDATE(@cell), [ZenQ Testing Required]:[ZenQ Testing Required], >=DATE(2020, 1, 1), [ZenQ Testing Required]:[ZenQ Testing Required], <=DATE(2020, 12, 31))


  • @Ryan Kramer , thanks for replying... I have to say sorry I'm a little lost.

    So, my current formula get's me my count: =COUNTIFS({ZenQ Testing Required}, ([Primary Column]3, @cell) > 0)

    So how would I add to that to get it to only count within the data range of the 2020 year? Looking at what you supplied I'm sorry to say I'm completely lost. The field from the connector that has the date is "Creation Date"

    So, I was thinking there be some type of extra IF statement around my current COUNTIFS statement, no?

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!