Create a sub task from a task
I need to start using sub tasks. I already have hierarchies built into my input sheet.
Much of the information on the parent must also be included in the child tasks
Is it possible to systemically copy data from a parent task into a sub task? Or Add a link to the parent record onto the child?
I'm not sure a formula will work since the formula will be overwritten as new records are created
Answers
-
Hi Stavros
May I ask what type of sheet you are refering to with this question? A Project Sheet's Parent task would be classed as a Summary Task and so it would summarise all its children, so the logic for the child having the same data wouldn't necessarily work here. However, if you are talking about a tracking type grid sheet, then it is possible to use some formulas to create some links back to parent row data.
Since the increased sheet capacity has been released, we have more columns to play with so you can collect data in one column and use a formula to concatenate / merge data from a parent with the child data.
If you could give an example of the type of thing you'd want to achieve. Maybe set up a sheet manually and highlight the bits that you'd need to pull in from the parent row then I could mock up a demonstration sheet for you (potentially)?
Hope this helps
Kind regards
Debbie
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.9K Get Help
- 439 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 67 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!