Auto update timeline column based on a date

Hi everyone.

I have a board with a timeline column where I currently manually enter a week timeline based on a date. For example if the date is 27th June the timeline would be Mon 26-Jun to Sun 2-Jul. All the relevant data is imported including the date field and then I have to manually add the timeline.

I am looking for a way to automate the timeline. I need the timeline because I have forumla’s based on the timeline that calculates Week Commencing, Week, Month, Year, Year-Week, Year-Month, Year-Qtr (as image below). I need all these for the dashboard graphs.

Thank you.

hi @MaxLogic_Lisa I may have just the app for you!

Take a look here and let me know if you have any questions (feel free to book a demo!): Date & Timeline Mutations -