Automatically manage subitem dates based on parent item dates or vice versa, set default dates when tasks are created, or track project timelines across all tasks.
- Project deadlines shift and you need all task dates to update automatically
- New tasks should have smart default dates (+3 days, +1 week from project start)
- You want to see the overall project timeline (earliest start, latest end) from all tasks
- Task due dates should change based on status (In Progress → Due in 5 days)
- You need recurring tasks created on schedules
Select based on what you're trying to accomplish:
When project deadline shifts by 2 weeks → All task (subitems) dates shift automatically
• Adjust all tasks by same offset• Adjust only tasks with certain status• Dynamic offset using Numbers column
New task created → Due date = Project start + 3 days (or any offset)
• Based on parent date + offset• Based on creation date + offset• Conditional: if task name = X
Automatically show earliest start and latest end from all tasks on parent item
• Roll up to parent timeline• Ensure parent starts/ends with tasks
Task status = "In Progress" → Due date = Today + 5 days
• Based on today's date• Based on parent date• Conditional by status
Every Monday → Create "Weekly Review" task automatically
• Every time period• When specific date arrives