Skip to main content

@rob

Does General caster works with date given with a formula?


My objectif is to put a deadline on a date calculated depending on the numbers of person working and the number of hours.


I already have a column with the calculated date. I want to use general caster to import the value on a date column. When i try it gives me “ivalid date”


Thank you very much!

Best,

@PierlucD


It may have to do with the way the date is formatted when calculated in General Caster.


Have you tried casting the formula to a Text Column? See if that gives you the date you want first, then we can troubleshoot further.


Hey @PierlucD

Please take a look at documentation on how date must be formatted.

https://general-caster.omnidea.it/documentation.html#how-formula-works-supported-columns


I solved it! This is what happend


If my formula column, wich calculated my due date, was referencing to another formula column general caster was’nt able to retreive the data.


So i had to do multiple general caster to retreive data from certains formula columns so that my calculated date column was calculted with number column only.


There’s another issue though.

Because i have 20 general caster thate modify 20 column every time i change a column it uses 400 actions and slow down my board. (@rob if you have a solution for that it would be great!)


Sorry for my english by the way haha i’m french. 🙂


In fact, is there a way to do a formula wich include other formula in it?


Let’s say I have these columns:


 - A delivery date
- Number of hours
- Deadline date (there is multiple deadlines - because of multiple steps)
- Number of people on certain steps

For the sake of the exercice, let’s say i have 3 steps. I want a timelime on each step depending on:


 - What is the delivery date
- how long a steps takes depending of this formula - (numbers of hours / 😎 / number of employe
- Then depending of the longer of the step make a timelime
- Repeat for the other steps depending of the previous timelime.

I don’t know if i’m clear hahaha.

Thank you for taking th time!



There’s no way to optimize it.

It’s the way monday.com works. Every time a column changes General Caster is triggered.


@PierlucD glad to hear @rob was able to help!


Let us know if you have any questions for our team 😃.


-Helen


This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.