Hello, I have a multiple if condition that returns a list, but what I need is for it to return the condition that is only true. Thankss!!!
if( {and( ri!tipo = "Alzada", a!isNotNullOrEmpty(ri!feRegistro), ), and( ri!tipo = "Reposición", a!isNotNullOrEmpty(ri!feRegistro), ), and( ri!tipo = "Revisión", a!isNotNullOrEmpty(ri!feRegistroAdmin), ), }, {ri!feRegistro + 90, ri!feRegistro + 30, ri!feRegistroAdmin + 30}, {ri!feRegistro, ri!feRegistro, ri!feRegistroAdmin} )
Discussion posts and replies are publicly visible
If all 3 need to be true, then use and(). Then return whatever single value you want to return when all 3 are true. Then whatever single value you want when they're not all 3 true.
If any of the 3 need to be true, use or(). Then whatever single value when any are true. Then whatever single value you want when all 3 are false.
If it's something else more complex than that, you might want to consider a!match(). Then you can specifically define each combination of your 3 inputs, and what it should return for each combination.
Agree