Trying to create a report that shows scheduled project manager work.

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

I want the report to show basically each project manager and how many days of work they have scheduled for projects during the current and following 3 months. The information I currently have to pull from is a start date, end date, and the total days for the project. Using a summary report showing any projects that are not complete and have an end date in the time period mentioned above, it just lumps all the days into one Month. For instance, if one manager has 4 projects that end in April that have a total of 50 days between them, the report puts all 50 days in April instead of breaking them down or the previous 2 months that they makes up those 50 days.

I am looking for a better way to set this up so that if a manager has 4 projects running from February to April totaling 50 days it shows that there are 10 days of work scheduled in February, 30 in march, and 10 in April.

Photo of Chris_MCD

Chris_MCD

  • 0 Points

Posted 3 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb
I recently answered a similar question.  When I get a chance I will look for it and provide the link.
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,806 Points 50k badge 2x thumb