Help

Need help with savingformula

Solved
Jump to Solution
619 2
cancel
Showing results for 
Search instead for 
Did you mean: 
Halima_EL_FARDI
4 - Data Explorer
4 - Data Explorer

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”,"")))

1 Solution

Accepted Solutions
Daniela_Hecht
6 - Interface Innovator
6 - Interface Innovator

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?

See Solution in Thread

2 Replies 2
Daniela_Hecht
6 - Interface Innovator
6 - Interface Innovator

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?

Halima_EL_FARDI
4 - Data Explorer
4 - Data Explorer

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: