Shared subasks
Hi everyone,
I have one problem I'm trying to solve for the last couple of days.
If you look at a picture below I have some group of preparation tasks and I have two delivery. Preparations in booth deliveries can have the same dependent tasks from preparation group of tasks. I´d like to attach somehow tasks form a bottom group to Preparation for delivery 1 and 2 and to show progress on those ones.
By using predecessors I'm not solving the problem since it will not show progress and start/end date as a sum of all depended tasks.
Simply I´d like Preparation for delivery 1 and 2 to behave the same as if I put directly under them as child tasks, tasks from preparation group of tasks.
Answers
-
Hi
Are you able to show us what you want to see as a result. I am sorry but I don't understand what you are trying to get to, so if you could provide the dates that you are getting now in an image and what you want to get to that might be easier for me to work on?
Many thanks
Purnima
Purnima Gore
Cierr Limited
Your Time is Important, you want to Stay on Track, We can help you use the Right Tools
-
Hi Cierr,
thanks for answer. Here are some sample.
So I´d like those 2 rows (preparation for delivery) to act as linked tasks are their child tasks
% should be caluclated based on % from tasks, dates should be start date when first tasks starts and end date when last one end, duration is for all tasks to be completed
Here is how it can be done by using just task/subtask structure but in real huge project Ill need to multiply tasks soo many times since there are lots of dependencies. So Id like to create one bucket of tasks and link for actual preparation. Maybe it not looks logical on this example but for real project it´s best option if possible
Hope so its more clear, pls let me know if you have more questions
-
It sounds like you'd like to reflect those % Complete and Dependencies for tasks not nested directly beneath the 'Preparation for Delivery' tasks. I'd be glad to assist with this. Currently, when Project Dependencies are enabled, the level of nesting or hierarchy dictates those (avg)percentages and completion dates that roll up into the parent rows.
If you will, please fill out this Enhancement Request form to provide your feedback to our Product Team on this request: https://app.smartsheet.com/b/form?EQBCT=739aa75f30ca43a8a22eb53e4da7d409
There is a possible way to show average % Complete by use of formulas. Below, I've created an AVG column next to the % Complete column that averages the children and another task in a different hierarchical section. The formula is AVG(CHILDREN(), AVG8):
One other suggestion may be to simplify your level of nesting and perhaps use the Status column to describe the state. See also in the screenshot above where a value for 'Preparation for Delivery' is used in Status instead of creating the parent section of the same name.
For more information on the topics above, please check out our resources below:
- Enable Dependencies and Use Predecessors https://help.smartsheet.com/articles/765727-enabling-dependencies-using-predecessors
- Project Sheet Columns: Start Date, End Date, Duration, % Complete and Predecessors https://help.smartsheet.com/articles/765737-project-sheet-columns-start-date-end-date-duration-complete-and-predecessors
- AVG https://help.smartsheet.com/function/avg
Kind regards,
Eric
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives