Help with 30/60/90 day view of resources


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?


Best Answer

  • Paul Newcome
    Paul Newcome ✭✭✭✭✭✭
    Answer ✓

    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))