Need Formula Help - Dates and Check Boxes

Justin Tackitt

I am trying to come up with a formula to count the number of items with any date within the month of January 2020 and have a box checked.

I was able to figure out the formula to get the total count of items within the month of January 2020 using this:

=COUNTIFS([Permit Start Date]:[Permit Start Date], IFERROR(MONTH(@cell), 0) = 1, [Permit Start Date]:[Permit Start Date], IFERROR(YEAR(@cell), 0) = 2020),

I would like to now have items within the month of January 2020 that have the "360 Photos Have Been Submitted" not checked. I tried the following but it did not work:

=COUNTIFS([Permit Start Date]:[Permit Start Date], IFERROR(MONTH(@cell), 0) = 1, [Permit Start Date]:[Permit Start Date], IFERROR(YEAR(@cell), 0) = 2020),[360 Photos Have Been Submitted]:[360 Photos Have Been Submitted], 0)

I see the columns being highlighted but I get an "Unparseable" error.

Any help would be greatly appreciated!

Andrée Starå

Hi @Justin Tackitt

You were close. You only have an extra parenthesis after the year 2020.

Try this one.

=COUNTIFS([Permit Start Date]:[Permit Start Date], IFERROR(MONTH(@cell), 0) = 1, [Permit Start Date]:[Permit Start Date], IFERROR(YEAR(@cell), 0) = 2020, [360 Photos Have Been Submitted]:[360 Photos Have Been Submitted], 0)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Andrée Starå

Hi @Justin Tackitt

You were close. You only have an extra parenthesis after the year 2020.

Try this one.

=COUNTIFS([Permit Start Date]:[Permit Start Date], IFERROR(MONTH(@cell), 0) = 1, [Permit Start Date]:[Permit Start Date], IFERROR(YEAR(@cell), 0) = 2020, [360 Photos Have Been Submitted]:[360 Photos Have Been Submitted], 0)

Did that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Justin Tackitt

It worked!!! I'm happy to know I was at least close.

Thank you so very much for your help. Very much appreciated!!!!

Andrée Starå

@Justin Tackitt

Excellent!

You're more than welcome!