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.
SOLVED (apparently). I reordered conditions so that 4 became 2, and 2 became 4
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |