@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”
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!)
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 / 8) / 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!