Automatically Adjust Subitem Dates Using Date + Offset Automations



Introduction

Managing project timelines often means setting task dates relative to a project start or due date.
When those dates change, manually updating every subitem quickly becomes time-consuming and error-prone.
With Subitem Automations, you can automatically calculate and shift subitem dates using date + offset logic — so timelines stay accurate without manual work.
This article explains:
  • What “date + offset” automations are
  • When to use each type
  • How to set up the most common use case step by step

What it does

Set subitem dates automatically based on your project start date.
Example:
  • Project starts November 1
  • Task 1 = Start + 5 days → Nov 6
  • Task 2 = Start + 15 days → Nov 16
  • Task 3 = Start + 25 days → Nov 26
Project delays to Nov 5? All tasks shift automatically.

When to use this

Check Mark Button You run the same project type repeatedly Check Mark Button Task dates are always relative to project start Check Mark Button You're tired of manually updating dates when timelines change
Managing project timelines often means setting task dates relative to a project start or due date. When those dates change, manually updating every subitem quickly becomes time-consuming and error-prone.
With Subitem Automations, you can automatically calculate and shift subitem dates using date + offset logic — so timelines stay accurate without manual work.
This article explains:
  • What “date + offset” automations are
  • When to use each type
  • How to set up the most common use case step by step


What is a “date + offset” automation?

A date + offset automation sets or adjusts a subitem’s date based on another date — shifted forward or backward by a defined amount.
For example:
  • Task due date = Project start + 5 days
  • Subitem due date = Parent item due date + value from a Numbers column
  • All subitems move by the same number of days when a project date changes
Offsets can be:
  • Fixed (e.g. +5 days)
  • Dynamic (based on a Numbers column)
  • Relative (shift by the same amount as the parent date)


Common use cases

Date + offset automations are commonly used for:
  • Project templates with relative task timelines
  • Automatically rescheduling tasks when project dates change
  • Setting default due dates when subitems are created
  • Status-driven deadlines (e.g. “When task starts → due in 3 days”)
  • Sequential or dependent tasks


Setup (5 minutes)

Step 1: Create Numbers column

Add a Numbers column to your subitems board.
Name it "Offset" or "Days After Start"

Step 2: Enter offset values

For each subitem, enter how many days after project start it should be:
Subitem
Offset
Discovery Call
3
Kickoff Meeting
7
Requirements Doc
10
Design Review
14
Development Start
21

Step 3: Add the automation

Go to Automations in your board.
Search for: "When item's date changes"
Select: "When item's date changes, change its subitems date to the same date with + offset by this number column of days/weeks/months"
Configure:
  • Parent date column: Your project start date (e.g. "Start Date")
  • Subitem date column: Your task due date (e.g. "Due Date")
  • Numbers column: Your offset column (e.g. "Offset")
Click Create.

Step 4: Test it

Change your project start date.
Watch all subitem dates update automatically.


Example

Project start: January 1
  • Discovery Call (offset 3): January 4
  • Kickoff (offset 7): January 8
  • Design Review (offset 14): January 15
Project delays to January 5:
  • Discovery Call: January 8 Check Mark Button
  • Kickoff: January 12 Check Mark Button
  • Design Review: January 19 Check Mark Button
Zero manual work.


Use Negative Numbers for Tasks BEFORE Project Date

Planning an event? Tasks often happen BEFORE the event date.
Use negative offsets:
Task
Offset
Venue Booking
-90
Send Invitations
-45
Confirm Catering
-30
Final Headcount
-7
Event Setup
-1
Event date: March 15
  • Venue Booking: December 15 (90 days before)
  • Send Invitations: January 29 (45 days before)
  • Event Setup: March 14 (1 day before)


Common Mistakes

Cross Mark Setting the same offset for all tasks

Result: All tasks get the same date (everything happens on day 5)
Fix: Use different offsets to keep tasks properly spaced

Cross Mark Creating multiple automations for the same date column

Result: Automations conflict and dates update incorrectly
Fix: Use ONE automation with a Numbers column to handle all tasks

Cross Mark Forgetting to enter offset values

Result: Some tasks don't update
Fix: Make sure every subitem has a number in the Offset column


When to Use This

Check Mark Button You run the same project type repeatedlyCheck Mark Button Task dates are always relative to project startCheck Mark Button Project timelines often shiftCheck Mark Button You're tired of manually updating dates
Examples:
  • Client onboarding projects
  • Product launches
  • Event planning
  • Construction schedules
  • Content calendars


Other Date + Offset Options

The setup above is the most common. But there are other triggers:

When a subitem is created (based on parent item date)

Auto-set the due date when creating new tasks.
Recipe: "When subitem is created, set its due date to match its parent due date + offset by this number column of days/weeks"
Use for: Checklists, dynamically created tasks


When subitem's status changes (based on parent item date)

Set deadline based on when work starts.
Recipe: "When subitems status column changes, set its due date to match its parent item due date + offset by this number column of days/weeks/months"
Use for: Checklists, dynamically created tasks


When subitem's status changes (based on current date)

Set deadline based on when work starts.
Recipe: "When subitem’s status changes to something, set its date to today + offset"
Use for: SLAs, time-sensitive handoffs


Sequential tasks

Each task starts when the previous one finishes.
Recipe: "When subitem’s date/timeline column changes adjust the date/timeline of the following subitem by the same offset"
Use for: Task chains, phased work


Troubleshooting

Problem: Dates aren't updating when project date changes
Check:
  • Automation is active (not paused)
  • Parent date column name matches what you selected
  • Offset column has values for all subitems
Problem: Dates calculating incorrectly
Check:
  • Positive numbers = days AFTER project start
  • Negative numbers = days BEFORE project start
  • Offset values are correct (5 not 50)
Problem: Some subitems update, others don't
Check:
  • All subitems have offset values entered
  • Offset column is a Numbers column (not Text)


Need help setting this up?

Our team is happy to help you configure the right automation for your workflow.Reach out anytime — we’re here to help.
  • Email:  support@fantasymedia.io