Insert dates from week column

Platform discussions Special workflows & use cases
1

Is it possible to add automatic the dates in the timeline column after selecting the week in the week column?

1 Like
2

Hi!

Option 1: Use Automations

  1. Add a Week Column (shows Week #) and a Timeline Column.
  2. Use an automation recipe like:

When Week changes to X → Set Timeline to [Start + End Dates for that week]

  • You’ll need to create an automation for each week value if you want it to auto-populate specific ranges.
  • Example:
    • “When Week is 32 → Set Timeline to 08/04/25 – 08/10/25”

This is manageable if you only need a small number of recurring weeks.

Option 2: Use a Formula + Date Columns

If you want dynamic calculations:

  1. Add a Date Column for the start of the week.
  2. Add a Formula Column to calculate the end of the week:

pgsql

CopyEdit

{Start Date} + 6
  1. Use an automation to mirror these two dates into your Timeline Column:

When Start Date and End Date changes → Set Timeline to Start → End

This gives you a rolling automatic timeline without manually mapping each week.

Option 3: Use Make (Integromat) or Zapier

If you want fully dynamic automation without dozens of recipes:

  1. Trigger: “When Week Column changes.”
  2. Scenario: Calculate the start date of that week, then auto-update the Timeline column with the start and end date.
  3. Benefit: No need to manually build automations for every week.