@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.
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.