Hi all,
I would like to know if there is an option to change my timeline automatically with respect on “Start date” change?
I have a “start date” and “duration” column, instead of adjusting a timeline I want to find an option to do it without any actions from my side.
Thanks for answering!
Hi @IlonaK - you would need to use a 3rd party app to manage casting the Start Date + Duration into a Timeline column. This can be easily achieved with General Caster with the following integration:
You would set this up for both the Start Date & Duration columns.
Then use the following as your formula"
CONCATENATE(TEXT(DATEVALUE({item's Start Date}), "YYYY-MM-DD"), "+", TEXT(DATEVALUE({item's Start Date}) + {item's Duration}, "YYYY-MM-DD"))
Hope this helps!
Mark
1 Like
Hi Mark,
Thank you for the answer, but I wanted to see if there is another option without purchasing additional applications.
@IlonaK - General Caster does have a free tier depending on your usage.
Mark
Thanks Mark,
I’ll try it, it’s the only option that provided in monday.com?
Hi Mark,
I’ve added this to my board but I get the generic error message General Caster Formula Error: An unexpected error occurred. Do you know what causes the error and how I get General caster to work? Thanks!
Hi @OKathy - if you copy & pasted the formula the column names may not match. Also, depending on your boards item terminology (ie “item’s” in the formula) there could be a discrepancy. Have you tried following the example but building it from scratch?
Mark
Hiya! Thanks for your speedy reply! Yeah I updated the column names to match the names in my board and have also tried creating the formula from scratch.
Hi there, were you able to figure this out? I have been stuck too.
thank you
That’s definitely possible with Smart Timeline + Duration. You can set up an automation so that whenever the Start Date changes, the Timeline and Duration update automatically, no manual edits needed.
Happy to show you how to set that up if you’re open to using apps. Just let me know!