Hello, I'm having a little bit of trouble wit...

(Jenn M.) #1

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.

(Jenn M.) #2

SOLVED (apparently). I reordered conditions so that 4 became 2, and 2 became 4