If THIS and THAT THEN

[erwblo]

I want a column that goes like this:
If SUBSCRIPTION STARTED is TRUE ‘AND’ SUBSCRIPTION ENDED is FALSE then 1, else 0.
I don’t seem to get that working in the In This Then Else column. Is this not how ‘add case’ works, or do I do something wrong?

[Jeff_Hager]

An IF column does not use AND logic. It’s basically always OR logic.

I would structure it like this:
IF Started is false THEN 0
IF Ended is true THEN 0
ELSE 1

[erwblo]

Thanks! Good to know!

[Jeff_Hager]

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…