Project Metadata sheet for each project or Master Metadata sheet. Which is best?
I've just started working with Smartsheet. The Learning Center is very helpful and I'm setting up a proof of concept in the trial version following the directions here for setup: https://app.smartsheet.com/b/publish?EQBCT=8c1ace8ce2d14472a986005d454626d8 I have a single Project Intake Sheet with all projects on it and I'm starting to create the Project Metadata sheets. The directions read as if there should be a separate metadata sheet for each project, but that seems as if it may be cumbersome to report off hundreds of separate metadata sheets later in any type of rollup report or dashboard. Should there just be a master project metadata sheet or is it really best to have a separate one for each project?
Thanks for any insight.