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.
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.
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.
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?
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
