πŸ’‘ General Caster - Formula Tip - From Date to Timeline

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.

1 Like

Hey @rob :wave:

Love how you’re supporting the app here and helping our users out with a use case that’s definitely common! Some of our users would definitely enjoy using this :slight_smile:

-Alex

1 Like