Math calculation between rows

[Darren_Murphy]

@Bander

I had watched that video but I still find the IF formulas to be lacking. For example I want to do another IF formula in the “else” response.

Next time you hit one of those cases, share it here and we’ll see if we can help with a way.
When you have multiple conditions or need to do a combination of AND/OR, generally the way is to work backwards and eliminate all the failing conditions first. One important thing to be aware of is that the if-then-else column will return as soon as it meets a matching condition, and you can take advantage of that.

For example, let’s say you want to express the following logic in an if-then-else column:

• If A is true AND (B > 10 OR C > 10), then true

At first glance you might think the above isn’t possible, but it’s actually quite simple. It’s just a matter of reversing the test for A, and short circuiting the flow if it doesn’t pass. So…

• If A is not checked, then null
• If B is greater than 10, then true
• If C is greater than 10, then true

Which gives:

The above approach won’t work for all cases, but it will work for many.
All that said - yes, it could be better. And you’re not the first one to have mentioned that.

Better and more consistent IF THEN logic

I’ve spent the past few days trying to work out some IF/THEN logic for a side project. The problem is that this is something I could have worked out in a matter of a few minutes with actual code. I’m running into several limitations with the current IF/THEN logic we currently have in Glide. First of all there inconsistencies between what’s possible with an IF/THEN column, and what’s possible with If/Then logic in visibility conditions or actions. Most importantly, an IF/THEN column only all…