Baselines for New Tasks
I use the baseline feature with the GUI extensively in my projects. During project execution, I frequently am adding/removing tasks to reflect the maturing scope of work. This means that unless I rebaseline the entire project (and lose historical projections in the process), these newly added rows go without baseline data. This is impacting a lot of my task health reporting. Is there a best practice that can be used to baseline only newly-added tasks, without rebaselining an entire timeline?
The only thing which comes to mind would be to copy-paste newly added start/finish dates into a static column, and use formulas which determine task health from the static column if the real baseline columns are blank for that row. However this becomes a very manual step, and I don't think my organization will have good compliance with this every time they add a task.
Thanks,
Ian
Answers
-
Hi @Ian Ix
You can re-set a Baseline but all the previous dates will update to anything you have moved the Actual Dates to as your project has progressed.
What I would do in this instance is use 3 helper columns: 2 Date columns and 1 Predecessor as you make the update:
- Copy/Paste your Actual Dates in their current state to two helper Date columns
- Copy/Paste your Predecessors into the helper Predecessor column
- Copy/Paste the Baseline Dates into your Actual Dates column (to revert them to the original state). This will remove your Predecessors which is why we had to copy them as well.
- Add in your extra rows/dates.
- Reset the Baseline so your Baseline now includes the new data
- Copy back the dates in the Helper Columns back to the Actual Dates so the Baseline updates to show the Variance so far.
- Copy back the Predecessors
- Delete the Helper Columns
I would suggest testing this out on a Copy of your sheet or a dummy sheet, first, to make sure this will work for your purposes. You can also let the Product team know of your feature request by filling in this form.
Cheers,
Genevieve
Need more help? 👀 | Help and Learning Center
こんにちは (Konnichiwa), Hallo, Hola, Bonjour, Olá, Ciao! 👋 | Global Discussions
-
Thanks Genevieve. Unfortunately I think this solution is much too cumbersome for us to be able to use. We add rows almost every week and this would disrupt our workflow pretty heavily. I appreciate your input but I've submitted a feature enhancement request.
-
@Ian Ix Did you find a solution to your problem? I have the same issue as well!
-
Nope, nothing new. I have a helper column which lets me manually enter a baseline when a new task is added, and all my baseline reporting looks at both the manual and GUI-based baselines, with priority given to any GUI-based dates present. Still an inelegant solution, but it's the best I've got.
-
I am having this same experience. Would love an option to baseline any tasks with a blank baseline
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.7K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 468 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!