Putting many projects into one sheet potential pitfalls
I supervise a small group that may have about 20 projects running. Project timelines vary from 3 weeks to 1 year in duration. I am trying avoid having multiple project deadlines fall on top of each other, so I have been looking for a tool to track project milestones at a high level. I have been watching smartsheet tutorials and I like the gantt charts, filtering functionality, reports, and dashboards features. I also like the ability to automate flags or status of projects that will be helpful for preventing projects from falling through the cracks.
I only purchased the Pro Plan, as I am the only one using it. Thus, I lose a lot of the functionality. In particular, I cannot have a report for multiple sheets. I am planning on just using one sheet for all projects and then I can create multiple reports and dashboards to summarize the information in a meaningful way. I guess I am wondering, is there a reason not to put all projects into one sheet? I plan on putting a checkbox function that moves projects to an archive sheet after manually checking off the items (say, if all boxes within a parent are checked off, then archive one week after). This would at least prevent the sheet from having too many rows.