Hello, I’m having a little bit of trouble with some IFS statements, input into the app formula field. I’m sure it’s a simple issue with the formula-- I’m not fluent in appsheet formulas.
In the attached image, conditions 1 and 2 go through with no problem-- the value of the column gets changed successfully as specified.
However, conditions 3 and 4 do not apply successfully – the value of the column stays according to the previous 2 conditions. If I remove condition 2 from the formula, condition 3 applies successfully as does condition 4 if condition 2 and 3 is removed.
Any suggestions? Thanks.