Skip to main content


General Caster


General Caster includes a collection of automation recipes aimed at performing enhanced calculations in monday.com without using a formula column .


Complete documentation is available here.



From Date to Timeline Formula


Given {item.date} your Date column placeholder, use the following formula:


CONCATENATE(FORMAT_DATE({item.date}, "YYYY-MM-DD"), ";", FORMAT_DATE(ADD_DAYS({item.date}, 5), "YYYY-MM-DD"))


to update your Timeline column with a range from Date to Date + 5 days.

Hi @Noelie2000

Of course you can.

Just take a look at our Ideas page:

generalcaster.app

Thanks. I’ve actually found the calculation but need it for a subitem which does not seem to be available:


CONCATENATE({item’s From}, “+”, {item’s To})


Unfortunately subitems are not directly supported yet due to limitations on monday’s side.

You can anyway add a Subitem Summary Column to the parent item and use General Caster with it.

Or you can use the Sync SubItem Timeline app from the marketplace.

(post deleted by author)

Just wanted to say Thank You for posting this solution. I’ve been searching the web for days trying to figure it out and this formula worked for what I do.

Hi @rob am trying to cast the formula but it doesn’t work.

I want to set up the timeline column with the date created (from the creation log date) and the end date from Due Date

So when I manually set the due date, the timeline will take the date when the item was created and the finish date from the due date.

Can you help me please?

Reply


Terms & ConditionsCookie settings