Managing complex, multi-sheet schedules

hollyconradsmith
hollyconradsmith ✭✭✭✭
edited 09/12/23 in Smartsheet Basics

We are building a large multi-family project. We set up our schedules to be broken out by building permit shell and units. There are 99 sheets in total built using the standard project template with some customizations.

Our plan was to roll up these sheets into reports that would allow a project manager to easily update multiple sheets at once. The problem is that dates cannot be updated in a report because of the dependencies.

This forces PMs to click into 100+ individual sheets to keep their schedules up to date on our complex schedules. Obviously, this is unacceptable.

Has anyone else dealt with a complete project like this?

How do we get around this?

Holly Conrad Smith

Director of Technology & Innovation 💡 at Streamline

CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony

Comments

  • I use this feature to see milestones (duration = 0) across multiple projects and am able to adjust the dates from the report which allows them to be updated in the sheet. The rolled up date would be dependent on everything else but you'd be able to update individual rows if they're showing up on the report. One caveat is that you'd have to save and reload/refresh the url for the schedule to actually repopulate with the changes.

    Another workaround I've used when wanting to split schedule views in the report (ie. schedule for subs, for client, for team members, etc.) is to add a checkbox column for each category and then run the report to pull back the line items with the desired checkbox.

    You may have already solved it but figured I'd share in case it's helpful.

  • I need the same type of reporting-1. Report for individual team leads to show all tasks due 15days. The tasks should be specific to the team. 2. Report for individual team leads to show all tasks past due. 3. All tasks with %complete is 0 and the start date is past due.

    Every report I have created has issues with the hierarchy of the schedule to the parent line is missing, etc.

    Also, the timeline report option is useless in showing a Gannt line across multiple teams. How do you select the lines you want for the timeline and then edit the Gannt bars with dates, colors, owners, etc.

    Where is MS Project when you need it. Does anyone has sample leadership reports (templates) that work for them and have figured standard heirarchy report issues.