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.
baseline - actual dates
I do the added columns now. We use it for both schedule and budget reasons. If you create a master row that does the functions that you need and copy it to fill out the sheet you need. We measure actual against planned and start date against actual start date. Some of these can be column hogs to get it done but the key is to build the three levels. Master Parent Row, Master Parent Child as we call It and then Master Child. We use this to be a template in the template and then build the sheet.
We have also used this is our sheet structures. Master Sheet to Master Budget sheets to Master Project Sheets to Project Sheets. They report both dates actual and planned and budget planned and actual up to the master sheets. I can then see at the parent rows at the top of each proect how many days past we are and how many dollars in the bdget are remaining overall and per task. The down side to all of this work is you need to watch the size you make your sheets as they can get large. Keep the page size in check and it works like a dream.
- See more at: https://community.smartsheet.com/discussion/baseline-functionality#sthash.2u1VnJKW.dpuf
Comments
-
Louise, try posting in that disucussion. Jeremy should be subscribed to new posts and will get an email when you post a reply.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.5K Get Help
- 424 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 145 Just for fun
- 62 Community Job Board
- 464 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 301 Events
- 39 Webinars
- 7.3K Forum Archives