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!
