Is there a recommended method for tracking multiple projects? A master sheet or doc that shows the status or project of multiple projects? We've done some basic sheet linking but there was no status update and it was fairly manual. It would be great if there was a way to create a line item in the master project document which then automatically create a new linked project spreadsheet (from a template).
Any suggestions or thoughts are appreciated!
Joe LaPara