We are trying to manage all our projects through smartsheet. I'm trying to determine if using one sheet for all projects or multiple sheets is best. We want to create reports and dashboards of all the projects to evaluate things like how may projects each project manager has, how many high priority vs. low priority projects, how many projects by current sprint, future sprints, etc. I'd also like to create some type of logic within projects for date dependencies. I started to create multiple project sheets, but found that if I create a rollup for my dashboard I have to create extensive formulas to read each project. When I create one sheet for all projects, the date dependencies seem to be for the entire sheet.
Does anyone have any insight into the best way to management multiple projects and do all the above? Or where in the help features I should be looking?
