How to use Dates to Timeline
Keep a Timeline column and your date columns in step.
Start and end dates to a timeline
- Your board needs two Date columns (for example Start and End) and a Timeline column.
- Open Automate, search for Dates to Timeline, and choose "When a date changes, set Timeline from Start and End". Add a second copy with "When an item is created" if new items arrive with dates already set.
With only one date set, the timeline covers that one day.
A timeline back to two dates
Choose "When Timeline changes, copy Timeline into Start and End". You can use both directions on one board: nothing is written when the value would not change, so they do not loop.
A start date and a duration
Choose "Set Timeline from Start and a duration". Use a Numbers column with the number of days, or a fixed number. Turn on workdays only to count Monday to Friday; a start on a weekend then moves to the next Monday. The start day counts as day 1.
Common messages
- End date is before start date: nothing was changed. Fix one of the dates and the timeline updates by itself.
- Dates too far apart: nothing was changed, because the dates are more than ten years apart.
- Duration must be at least 1 day: the number of days is zero or negative.
- Wrong start column type (or end, timeline, duration) or start column not found: edit the automation and pick the columns again.