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

Mark Schlaudraff

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?

Paul Newcome

To include the requirement of being in the year 2020 to your current formula, it would go something like this...

=COUNTIFS({ZenQ Testing Required}, FIND([Primary Column]3, @cell) > 0, {Other Sheet Date Column}, IFERROR(YEAR(@cell), 0) = 2020)

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

Mark Schlaudraff

@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?

Paul Newcome

To include the requirement of being in the year 2020 to your current formula, it would go something like this...

=COUNTIFS({ZenQ Testing Required}, FIND([Primary Column]3, @cell) > 0, {Other Sheet Date Column}, IFERROR(YEAR(@cell), 0) = 2020)