Project Plan with hour:min level predecessor
I have searched through several other posts and I have not been able to find anything related.
I have a use case for an hour-by-hour plan that will happen all within a single weekend. (Project cutover). I want to be able to update a start time and end time column based on a duration of 15m, or 1h, etc. I can use the minute or hour duration but I cannot find a way to have it update dependencies at an hour:minute level.
Example: I have task#1 that starts at 8PM and is 1hr duration to end at 9PM. I have a dependency task#2 that starts at 9PM and ends at 11PM. If I change task#1 to 9PM I would like have task#2 update to 10PM start automatically.
I suspect I could create a time formula to add time but it would be pretty tedious.
Does anyone have thoughts/ideas if you want an hour-by-hour project plan to update the time of the dependency tasks?
Best Answer
-
You are going to have to either do it manually or use a series of formulas. Below is a thread that has a lot of time based solutions. From there we would need to figure out formulas for working with predecessors/dependencies. I have a few ideas on that but have never actually put it into practice. It would require a column for each predecessor, so if you have 5 predecessors on a single row, you will need 5 additional columns to parse them out.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Answers
-
You are going to have to either do it manually or use a series of formulas. Below is a thread that has a lot of time based solutions. From there we would need to figure out formulas for working with predecessors/dependencies. I have a few ideas on that but have never actually put it into practice. It would require a column for each predecessor, so if you have 5 predecessors on a single row, you will need 5 additional columns to parse them out.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.5K Get Help
- 370 Global Discussions
- 202 Industry Talk
- 433 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 447 Show & Tell
- 29 Member Spotlight
- 1 SmartStories
- 280 Events
- 31 Webinars
- 7.3K Forum Archives