Great work, Kandis! I have been beating the "Scheduling Best Practices" drum for 50 years--as nothing can be more critical to project success. I applaud your ability to communicate these critical practices (e.g. work breakdown structure; resource loading; dependency linking; baselining) in an easily understood manner. What you are teaching is the "real deal"--not some dumbed-down version of building project schedules. And happily, the Smartsheet tool can support what you are teaching. Keep up the good work!
Great smartsheets info and way shorter than most out there (who has an hour to watch a tutorial?). It helped me as we had custom baseline columns in our sheets that we didn't even need - much smarter to use the functionality that's built in! Thank you.
this feature is interesting and useful. I have one question though, do you know if it is possible have the total or final VARIANCE value (the one in the summary) into a dashboard?
Thank you Kandis for the Baseline video. I am new to your videos and have been enjoying them. I use Smartsheet to schedule multiple projects at the same time. Is it possible to set a baseline for just a selected group of tasks?
Thanks, Chad! Glad you’re enjoying the videos. The baseline is either turned on or off for each project in Smartsheet, as it automatically adds the columns for tracking. I hope this info is helpful!
Hi Kandis, I am pretty new to smartsheets and trying to create a schedule on smartsheet i have done export to excel and import in smartsheet, but the problem faced are there are no WBS indents (which can be fixed easily), but how to make Activity id column as the row # so that smartsheet predecessor formula will work and pull exactly the same way P6 do please let me know link to any of your tutorial if you have already covered appreciate your help! Thanks
Hello Aniket! I recommend you explore setting up auto-numbering rows in Smartsheet. Check out this article and let me know if it meets your needs: help.smartsheet.com/articles/1108408-auto-numbering-rows
Hi Kandis - thanks for the great videos. You mentioned you can make additional baselines. How do you do that? If you remove it and reset it, do you lose your original baseline? Is there a way to save the previous baselines even while working based on an updated baseline? Thank you
Hello Zachary! Great question and while you can set new baselines, it does remove the previous one. Unfortunately, it isn't like MS Project where you can have multiple set at one time and compare the differences. Maybe in the future! Here is information on 'Resetting' a baseline: help.smartsheet.com/articles/2482093-baselines#toc-edit-or-remove-baselines-from-your-sheet
Yes, I completely agree with this. Those columns are intended to be actual dates while the baseline dates are the forecast you are comparing against to determine if you are behind schedule or ahead of schedule. Great suggestion!
Hi Kandis i would like to know if i can create Master schedule and have another sheet as milestone schedule that is tied to master schedule. i would like to know if i can use Smartsheet for pull planning
Hi Adan! YES, you can absolutely do this. Smartsheet actually has a template set called Project Tracking and Rollup that I cover in this RU-vid video: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-a7om6Sn0rkE.html. It has the project milestones report already set up, along with several other helpful sheets for tracking project progress. Definitely a huge benefit!
Hello! Unfortunately, I’m not aware of a workaround on being able to use baselines with a free account. From my understanding, you need at least a Pro account. Thanks for reaching out with your question!
Hi Kandis! Thanks for sharing this video! I have a question: When I updated my duration, it only changed my start date column not my end date column. I do have all my activities dependent on certain key dates. So could it be because of the predecessors I have set? I see you had predecessors, but all your following tasks end dates also changed accordingly. Thanks in advance!
Hi Maria - can you please confirm you are only updating the child tasks vs the parent tasks? If so, there is a good chance that not all end dates will change based on the predecessors you have set, just the ones that will be directly impacted by the change in duration!
Hi Tal! I don't believe Smartsheet has a simple way to show when the baseline was set. The approach I have used in the past is a workaround. You can view the 'Activity Log' and under "Actions' filter by 'Cell Changes'. I change the beginning 'Date Range' to 'None', which will allow you to see changes from the beginning of the project. When the baseline was set, it should show each of the rows listed with a cell change and the variance showing up as 0. The only way I know how to view the baseline being set is to comb through the cell changes to find the info. Hopefully they can add a date stamp to the 'Baseline' box in the future!
@@PMPexpert Thanks for the workaround. I will definitely give it a shot and once I find it, I'll note it in a cell somewhere.. that will be easier next time.
