Help with 30/60/90 day view of resources

Carrie Young

Hi,

I'm trying to build a report that will provide me a 30/60/90 day view of all resources. How many tasks are assigned to each resource in these time boxes. I'm finding if you have multiple resources assigned to a task the report doesn't count/assign it to both resources for example.

Is there any way around this?

Paul Newcome

Try something like this for within the next 30 days. Then you can adjust the number in the TODAY functions for the 31-60 and 61-90 ranges. 31 and 60 would go in the first TODAY function and 60 and 90 would go in the second.

=COUNTIFS({Source Sheet Assigned To}, FIND(Contact@row, @cell)> 0, {Source Sheet End Date}, @cell >= TODAY(), {Source Sheet Start Date}, @cell <= TODAY(30))

Paul Newcome

Are you able to provide a screenshot of your current setup?

Carrie Young

report above. example of tasks for Ben below

Paul Newcome

Ok. And how are you wanting to break it down? Separate counts for 0-30 days and 31-60 days, or would you want the 0-30 days included in the 60 day count?

Carrie Young

It would be separate; 0-30, 31-60, 61-90

Paul Newcome

Try something like this for within the next 30 days. Then you can adjust the number in the TODAY functions for the 31-60 and 61-90 ranges. 31 and 60 would go in the first TODAY function and 60 and 90 would go in the second.

=COUNTIFS({Source Sheet Assigned To}, FIND(Contact@row, @cell)> 0, {Source Sheet End Date}, @cell >= TODAY(), {Source Sheet Start Date}, @cell <= TODAY(30))

Carrie Young

Thanks much, I will try it.

Carrie Young

This worked well, thanks much!

Paul Newcome

Happy to help. 👍️