If THIS and THAT THEN

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?

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

4 Likes

Thanks! Good to know!

1 Like
2 Likes

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.