Writing multiple formulas with IF(AND(

Platform discussions
1

Hi, I am trying to create a formula to return a “1” for specific combinations of labels between two dropdown columns. This formula works for me IF(AND({POLE SIZE#Labels}=“65”,{POLE CLASS#Labels}=“1”),“1”,“0”) but I cannot figure out how to have more lines or add more labels without having the formula fail.
Any tips?
Thanks

2

Hi @Sean2g
I am facing the same problem.
This formula works well:
IF(AND({Prorroga Data?}=“SIM”,{Qtde Dias SEM HOLIDAYS}>“20”),“VENCIDO”, “No Prazo”)
But I need to add new conditional {Prorroga Data?}=“Não”
I believe that should be:
IF(AND({Prorroga Data?}=“SIM”,{Qtde Dias SEM HOLIDAYS}>“20”),“VENCIDO”, IF(AND({Prorroga Data?}=“Não”,{Qtde Dias SEM HOLIDAYS}>“10”),“VENCIDO”, “No Prazo”)“No Prazo”)
But it doesn´t work
Can someone help me?
TKS

1 Like