@Kaleb here it is: https://app.smartsheet.com/sheets/vX8g5HXPjj22Mq9VGfHXWCFXrHRhr4wcmQw47971
For the:
- New Baseline: with the formula =End@row
I actually changed it to manually add the data manually as soon as the new task is added, otherwise, it will keep updating everytime I change the end date.
In this example, activities 5 & 6 have been added after setting the baseline. Original end date was 09/25 (as stated in New Baseline column) and then I changed it to 09/27. After that, "Diff" column is either picking up the original Variance from the Var column or calculating whenever it is blank.
Adding New Task After Setting Baseline
Comments
-
I Am Unable to Access The Sheet. I (Tony) Requested Access a Few Minutes Ago. Thanks
-
@Kaleb sorry, seems I cannot share outside of my org. Let me see if this still helps:
Var, Baseline Start and Baseline Finish are default columns when you set the baselines.
Columns I added:
--> Diff = IF(Var@row = "", ([New Baseline]@row - End@row), Var@row)
--> New Baseline: manually enter the end date as soon as the task is added.
So Diff column is the recalculated variance.
Does it help?
-
We agree that when we add new tasks, we would like them added to the baseline instead of having to go and reset the baseline. It will reduce human error and save time. We had a company Smartsheet users meeting today and it revolved around this topic.
-
Ok, Thanks For Trying. I Will Try Your Formula and Let You Know The Results.
-
I am sure this has been mentioned, but the functionality for setting and modifying baseline dates needs to be expanded. It would be great to have the capability to modify a specific cell/cells and auto set the baseline date as a new task is added. Any idea when this functionality will be added?
-
@ju.harrison Yes, there are quite a few posts asking for this functionality. In 2023, Smartsheet marked one of them as "On our radar": Adding New Task After Setting Baseline — Smartsheet Community. You'd be best of submitting your vote and comment there.
-
Not being able to add tasks to a project after the baseline is set and then having to manually update everything back to the original dates to make sure we capture our planned vs actual correctly is one of the most frustrating and time consuming items… Especially when having 200 rows of data on a project. - Smartsheet please create this feature.
-
C'mon guys - 2 year and not solved? We really need this!
Michał Gosk
Project Manager @ Partner in Petfood 🐶🐱
mgosk@ppfeurope.com
-
Project plans are dynamic by nature. Rarely I have I had a plan which does not have new tasks added throughout the project. It would be super helpful for the tool to only set baselines for new tasks and not reset existing task baselines. I've added my vote and have fingers crossed this feature is added soon!
-
Suggested 2 years ago and still not updated. Very unfortunate and discouraging. Need Smartsheet to be more responsive and attentive to userbase, please.
-
why even use it - what a waste of my time
-
Being able to add baselines with new tasks is absolutely critical, this needs to be done ASAP
-
I just wanted to add a comment saying I too would like it if there were an option to set a baseline for new rows without having to re-set the baseline of all rows.
-
Another vote to add this feature!
- Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our prod…
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.5K Get Help
- 434 Global Discussions
- 152 Industry Talk
- 494 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 506 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 37 Webinars
- 7.3K Forum Archives
Trending Ideas
- A rand() function to generate a random number is REALLY needed, format doesn't matter - just SOMETHING that allows us to generate a random number inside of the program.
- It would be a time saving feature in place of the existing conditions feature function to have the option of a toggle on/off column filter feature that provide at the column a quick filtering options …
- The title says it all. The empty fields are an eyesore/unprofessional looking. Please add this feature to address a glaring shortcoming for SS and its users. Thank you!!