Using General Caster: Trying to automate Timelines based on Start Date and/or End Date, but struggling with formula errors

Platform discussions monday apps & integrations
, , ,
1

Hi everyone,

I’ve seen similar questions to this, but the solutions given are still coming up with “Unexpected Error”.

I manage a very small nonprofit, so I’m trying to set up my workspace to be as efficient as possible. I’m designing workflow templates for event management at the moment and I want to automate the timeline of each step based on either the end date for when we have fixed deadlines, or the start date.

I currently have the Timeline column linked with a Duration column, but I’d like to set up two automations:

  1. When the start date is changed, it changes the start date of the timeline and the number of days specified in the Duration column then determines the due date and populates the Due Date column

  2. When the End Date is changed, it determines the end date of the Timeline, and the Duration column then determines the Start Date and populates that column.

Ideally, I’d like to figure this out with General Caster as their free tier with 500 ops/month is likely to be sufficient for us for the time being. The nonprofit I work for doesn’t have the budget for paid add-ons at this time.

For reference, this is the formula I’ve tried from other forum posts on this topic:

"When “Start Date” changes, perform formula:

CONCATENATE(TEXT(DATEVALUE({task’s Start Date}), “YYYY-MM-DD”), “+”, TEXT(DATEVALUE({task’s Start Date}) + {task’s Duration}-1, “YYYY-MM-DD”))

And cast result to Timeline"

Any help is greatly appreciated!