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

Louise O'Day
edited 12/09/19 in Archived 2015 Posts
This post is in regards to this post below.  I would like to get in touch with Jeremy michels to see if he will share the sheets he references with me.
Any help will be appreciated
Thanks so much
Jeremy Michels601 pts
April 5, 2015 8:30 pm

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


This discussion has been closed.