IF/AND Formula not working Hi Airtable community !
I’m new to formulas, loving it but struggling a bit as well…
I’m trying to automate a change in my records, from a phase of the process to the next, at a specific date using IF/AND.
I created a fromnow field called “Calculation” and when it gets to 0 days, I would like to change my Phase en cours to the next phase. It looks like this :
IF(
AND(
{Calculation} = “0 days”,
{Phase en cours}= “Envol 2”
),
“Accélération 3”,
IF(
AND(
{Calculation} = “0 days”,
{Phase en cours}= “Accélération 3”
),
"Accélération 4”,
IF(
AND(
{Calculation} = “0 days”,
{Phase en cours}= “Accélération 4”
),
“Propulsion 5”,
IF(
AND(
{Calculation} = “0 days”,
{Phase en cours}= “Propulsion 5”
),
“Propulsion 6”,
IF(
AND(
{Calculation} = “0 days”,
{Phase en cours}= “Propulsion 6”
),
“Coaching terminé”,
)
)
)
)
)
It’s unfortunately not working and I can’t figure out why :frowning: (it says “Sorry, there was a problem creating this field. Invalid formula. Please check your formula text.”)
Thanks
