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
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives