Hey @rob 👋

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 🙂

-Alex

Do you have any idea why this formula

CONCATENATE({3},’ ‘,{1#Labels},’ ’ ,FORMAT_DATE(TODAY(), “YYYY-MM-DD”))

does not work for me in the General Caster integration ??

Hey @HJH

Please replace {3} and {1#Labels} in your formula with the correct placeholders you get when you click on the corresponding column button in Formula field (.i.e. {item.status}).

hey it’s not working even when i do this

CONCATENATE(‘j’ , {item.long_text6})

or:

{item._____18}

which is drop-down column label that i took from the Formula field .

I did play with it a lot and try different ways to get this to work . the only label that gets result is the item name .

It seems that the automation doesn’t recognize the labels from the formula field .

maybe the monday structure itself got changed lately and causing the general caster automation to not working properly ??

Hei @HJH

Hi John,

sorry for our late reply to your General Caster bug report.

We were working on a completely new version of General Caster with improved speed and functionalities.

Would you like to give it a try?

Here’s the link to install it.

Please let me know if it works.

Hi guys,

I’ve been trying to use the formula above. I’m copying exactly what @rob wrote in his first message with my column ids and it doesn’t work.

I write this in the formula field of the integration:

CONCATENATE(FORMAT_DATE({item.date_19}, “YYYY-MM-DD”), “;”, FORMAT_DATE(ADD_DAYS({item.date84}, 5), “YYYY-MM-DD”))

I get this error: “General Caster Formula Error: Unexpected ,”

Any ideas on how I could solve this?

Thanks!

General Caster recently migrated to a new more powerful and faster platform.

The “perform existing formula” integration is now gone due to small differences in the syntax used in the Formula column and in General Caster and some of your formulas must be updated.

We are going to publish a complete documentation. In the meantime, you can take a look at

https://phpspreadsheet.readthedocs.io/en/latest/references/function-list-by-name/#function-list-by-name

In order to check what’s wrong with your formula, please check what the result actually is by casting it into a temporary Text column and change it accordingly.

In particular, FORMAT_DATE and ADD_DAYS functions are not available anymore.

Just use the following formula.

CONCATENATE(TEXT({item.date_19}, "YYYY-MM-DD"), ":", TEXT({item.date84} + 5, "YYYY-MM-DD"))

Great, thanks @rob !

The result in a text column appears like this: 2021-03-19:2021-03-31

How can I cast this to a Timeline column instead of a text column?

I have the same problem… @rob

Hey @AliBri and @Amelie

Sorry for the confusion.

Here’s the correct formula:

CONCATENATE(TEXT(DATEVALUE({item.date4}) + 10, "YYYY-MM-DD"), "+", TEXT(DATEVALUE({item.date4}) + 20, "YYYY-MM-DD"))

It takes a date and create a timeline from “date + 10 days” to “date + 20 days”.

Hi, thank you, unfortunately I can’t add the General Caster integration…

I tried this:

CONCATENATE(TEXT(DATEVALUE({Start Datum}) + {Planned days pro MA}, “YYYY-MM-DD”), “+”, TEXT(DATEVALUE({Start Datum}) + {Planned days pro MA}, “YYYY-MM-DD”))

adapting your formula and it gives me now for example 44266+44266 as a result…

@Amelie

Update column references…

okay, where can I find the references ? or where can we update it ? Sorry I don’t get it 🙂

Hello!

I’m trying to install General Caster via this link as the app doesn’t seem to appear in the monday market, but I keep receiving the same message:



Is there any other way to install it?

@Lucia1

Use this link:

@Amelie

Although Formula column syntax is similar to Excel syntax, there are some differences.

If you are converting all your formulas from Formula column to General Caster, you can’t simply copy the formula from the column and paste it into the formula composer in General Caster.

In the Formula column, when you click on a column reference, {column_name} is added to the text. General Caster uses a slightly difference reference, for example {item.column_id} . Just click on the corresponding column button at the bottom of formula composer in General Caster to get the correct column reference.

It works! I love this integration @rob, thank you so much!

Happy planning 🙂

Hi Rob,

Appreciate the support for the app here. I’m trying to accomplish the opposite of the original post, in a way. I want to extract the Start Date of an existing Timeline Column so that I can use the start date to trigger a monday.com automation. Is this going to be possible using General Caster?

Thanks,

Just take a look at GC Ideas page:

https://generalcaster.app/website/ideas/

Something like LEFT({item.timeline}, 10)

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

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

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

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

hi @Noelie2000

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

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

Thanks.