Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Best way to set up a sheet to track multiple IT projects
Our IT department has several projects we want to track. I need advice on the best way to set up the sheet(s) so that we can see the details of each project and have the ability to see all of the projects on one sheet.
Which option would be the better set-up?
Option A - Have one sheet that lists of all the projects with each project having it's own hierarchy on the sheet (I am concerned that the sheet could become too big and onerous to work with.)
Option B- Create a separate sheet for each project with all the tasks under one hierarchy and then linking that cell n the project sheet into an IT project summary sheet. (It seems that it may not be possible to see each of the project details simultaneously in the same sheet?)
Maybe, you can suggest another option that would be better than either A or B?