Parent roll up function splitting the gaps in child dates
hi Team,
New user here on SS.
I am wanting to develop a sheet with a gantt chart for my teams leave. It would have categories of the team name and second level category of their names.
I was hoping when they add a row for planned leave, it will show in the parent of their name, followed by the parent of the team name. This is occurring however if one team member has a row for planned leave from 22/02/2024 to 01/03/2024 and another team member has a row for planned leave from 29/09/2024 - 31/11/2024, the parent roll ups have it covered from 22/02/2024 - 31/11/2024 continuously.
Is there a way to enable parent rows to leave the gaps between the dates?
Kind regards,
Craig
Answers
-
Hi Craig, welcome to the Community! Could you provide a screenshot of your sheet, with sensitive data blocked?
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.7K Get Help
- 371 Global Discussions
- 203 Industry Talk
- 436 Announcements
- 4.5K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 129 Community Job Board
- 448 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 282 Events
- 32 Webinars
- 7.3K Forum Archives