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