Need help with savingformula

HEY,
I don’t know why air table don’t save this formula
Do have a problem with the formula?or it’s a little long. I don’t really know where the problem seems to be is.
Please help Me !!!
IF({RECEPTION},IF(IS_AFTER(TODAY(),“DATE ECHEANCE”),“NON PAYEE”,“ENCOURS DE PAIEMENT”,IF({ENCAISSEMENT},“PAYEE”,"")))

Hey Halima
Not sure what you’re trying to do with that formula but it seems to me that the second IF function has 4 parameters where there should only be 3:
Parameter1: condition IS_AFTER(TODAY(),“DATE ECHEANCE”)
Parameter2: value if true: “NON PAYEE”
Parameter3: Value if false: “ENCOURS DE PAIEMENT”
Maybe after this you should close the IF with ) so that the IF({ENCAISSEMENT},“PAYEE”,"") part belongs to the first IF instead of the second.

My guess would be something more like
IF({ENCAISSEMENT},“PAYEE”,
IF({RECEPTION},
IF(IS_AFTER(TODAY(),“DATE ECHEANCE”),
“NON PAYEE”,
“ENCOURS DE PAIEMENT”),
“”)
)
but not sure that’s the behavior you need or what you want to get from that first IF so I really don’t know, maybe explain a little?

1 Like

Thank you , I appreciate :smiling_face_with_three_hearts:
that worked!!
I just needed to change the orders of fonctions to make it logical
:pray: :pray: :pray:

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