💡 General Caster - Formula Tip - From Date to Timeline

monday Apps & Developers Share your monday apps!
21

I am trying to create an automation using the following formula with General Caster. This should pull the Start Date from the Current Timeline based on what’s advised above. It is not working with this code but code seems correct. Can anyone help please?

SWITCH(TEXT(LEFT({item’s Timeline}, 10),“MMMM”)),
“January”, “January”,
“February”, “February”,
“March”, “March”,
“April”, “April”,
“May”, “May”,
“June”, “June”,
“July”, “July”,
“August”, “August”,
“September”, “September”,
“October”, “October”,
“November”, “November”,
“December”, “December”)

22

Hey @declan.maher
The formula is not correct.
Once you get the “start” part of the timeline you need to convert it into a valid date with DATEVALUE() function.
Then you’ll be able to get the corresponding month without the need of SWITCH() function.

TEXT(DATEVALUE(LEFT({item’s Timeline}, 10)), "MMMM")

23

That’s amazing Rob. Many thanks for the swift reply. That works perfectly.

1 Like
24

Has anyone used General Caster to populate a Timeline from two dates - Start - Finish?

25

hi @Noelie2000

There is an app dedicated to do that, see https://monday.com/marketplace/18

26

Thanks I was hoping to use General Caster to get value out of it but will look at your solution.

Thanks.

27

Hi @Noelie2000
Of course you can.
Just take a look at our Ideas page:

28

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})

29

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.

30

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

1 Like
31

(post deleted by author)

33

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.

1 Like