I’ve added this formula which processes and the log shows it succeeded but I also get a notification stating ‘an unexpected error occurred’:
CONCATENATE(TEXT(DATEVALUE({item’s Start Date}), “YYYY-MM-DD”), “+”, TEXT(DATEVALUE({item’s Start Date}) + {item’s Duration}-1, “YYYY-MM-DD”))
My Board looks like this:
Any ideas why the formula fails to update the Timeline when I change the Start Date?
While I have not used General Caster and am an sure why the error is occurring. It could be due to the format monday needs to receive timeline information in but am not sure how General Caster handles that. So I would reach out to them specifically as they should be able to help you fix the formula to get your result (assuming they can post to Timeline columns). .
I also have an app going through the review process right now that will allow you to set and update timeline columns. This will be one of the features that when a column changes you can set the start date of a timeline as another date column and keep the existing duration allowing you to update a timeline. If the timeline doesn’t exist you can use another recipe option that allows you to use a date column to set the start date and a number column to set the duration. You can see more here: Date & Timeline Mutations - simplifiedworkflows.com
Hey @abonsey - you might find our new Smart Timeline + Duration app really helpful for managing dates, statuses, reminders, and assignments. It extends the native Timeline and Duration columns in ways that aren’t possible out of the box, all powered through automation, making your workflows way more dynamic and efficient.
Feel free to give it a look, and I’d love to hear your feedback or even walk you through it live if that helps!
