A customer schedules their yearly projects by week number. So when building out a template board, we can set a number column to be the week of the year that item is due.
How can I push that data into a timeline column so that when a board is created from the template, they can assign a start date and the timelines will auto-populate based on the week number assigned to that item?
Hi Derek @derekbosomworth - you can set that up using this automation recipe:
When the week number is set,
display the corresponding timeline in this column.
Simply enter a date, and it’s instantly converted into the correct week number, which automatically updates the corresponding timeline.
Since your client schedules everything by week number, you can trigger automations based on week number logic, and run workflows based on weekly planning without formulas or workarounds.
Check out Smart Week Number on monday.com
Regards,
Avo