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.

Multiple projects on one sheet

Carol Key
Carol Key ✭
edited 12/09/19 in Archived 2016 Posts

We have several large projects that require their own sheets.   However, we also have many small projects that do not justify creating separate sheets.   They are quick one or two day jobs, but they affect scheduling and P&L need to be factored into that.     Does anyone out there use one sheet for multiple small projects?   And if you do, how do you get the data from them (budget, start/end date, etc) into reports and such?   

Tags:
· Share on FacebookShare on Twitter

Comments

  • Sean
    Sean ✭

    One method we use is to have a default value in a hidden column that allows you to only report on specific rows accross multiple sheets. you can then narrow the report query paramaters using your date or resource fields.

    · Share on FacebookShare on Twitter
  • J. Craig Williams
    J. Craig Williams ✭✭✭✭✭✭
    edited 04/22/16

    Carol,

     

    I think Sean's answer is the way to go.

    I used project codes in a column. I don't bother to hide them, usually.

     

    Did you get what you needed?

     

    Craig

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories