If I have a formula with IF(Lookup(A)-Lookup(B)=10, โThis is fineโ, Lookup(A)-Lookup(B))
Is appsheet keeping these Lookup values from the condition for the else statement or does this statement consist of 4 lookup actions for every row regardless of A-B=10?
I believe the else expression is evaluated separately; the computed values from the if expression are not reused.
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |