Hello, I’m trying to create an automation based on the linked timeline and duration columns. The functionality we want is: we enter the material lead time (in days or weeks), then the timeline column shows that amount of time from today. So if today is March 10th 2025, and the lead time is 14 days, then the timeline should show 3/10/2025 - 3/24/2025.
Currently the timeline doesn’t update with today’s date, it uses a fixed date. I’m looking for functionality similar to =today in excel so that the timeline always starts with today as the beginning of the duration. I’ve tried a few automations to create this, but they haven’t worked.
Thank you!