Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Need help with savingformula

Solved
Jump to Solution
1220 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: