How to use Dates to Timeline

Keep a Timeline column and your date columns in step.

Start and end dates to a timeline

  1. Your board needs two Date columns (for example Start and End) and a Timeline column.
  2. 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