Countifs for today calculation

Jbro

Hi there! I'm trying to bring items from multiple sheets to populate a metric sheets. Basically, I would need a hand to bring the following data to count how many check box items have been modified on the last 7 days and more than 7 days. This check box row items can be level 2 or 3, the column name is Level.

Count ifs last 7 days:

Checkbox is marked, on level 2 and 3 rows. (Hierarchy)

if modified is on the last 7 days from today.

Count ifs more than 7 days:

Checkbox is marked, on level 2 and 3 rows. (Hierarchy)

if modified is more than 7 days from today

Thank you!

Eric Law

Hello @Jbro,

You can use the TODAY() function for both, I don't know if you want them combined into 1 formula or not, here are the 3 different ones you can try.

=COUNTIFS(Modified@row, =TODAY(-7), Hierarchy@row, =1)

=COUNTIFS(Modified@row, <TODAY(-7), Hierarchy@row, =1)

Combined:

=COUNTIFS(Modified@row, <=TODAY(-7), Hierarchy@row, =1)

Jbro

Hi Erik, can the Hierarchy work if I am sourcing from another sheet? Sorry forgot to mention that detail.