How do you adjust the parent task to only show months worked? (rather than being a continuous line)
Currently, we have tasks set under a parent, but the parent will only show between the start and end date. If there is a 3 month gap in between, how do you display this in the parent?
For example one task is done in January and another in March. - How do you show a split in February?
Answers
-
This is one of my pet-peeves about the product but actual time gone by is apparently a huge priority for project management. If you want to create a Time on Task column you can run a formula to calculate each sub row by subtracting the end date from the start date to get an actual number, then in the parent rows you can sum the children rows.
Formula for the child rows: = [End Date]@row - [Start Date]@row
Formula for the parent rows: =SUM(CHILDREN())
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives