# If THIS and THAT THEN

**URL:** <https://community.glideapps.com/t/if-this-and-that-then/47626>\
**Category:** Ask for Help\
**Created:** [August 24, 2022, 12:44pm UTC](https://community.glideapps.com/t/if-this-and-that-then/47626 "2022-08-24T12:44:52Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [August 24, 2022, 12:44pm UTC](https://community.glideapps.com/t/if-this-and-that-then/47626/1 "2022-08-24T12:44:52Z")

</div>

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?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 24, 2022, 12:48pm UTC](https://community.glideapps.com/t/if-this-and-that-then/47626/2 "2022-08-24T12:48:31Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)\
**Post date:** [August 24, 2022, 12:50pm UTC](https://community.glideapps.com/t/if-this-and-that-then/47626/3 "2022-08-24T12:50:24Z")

</div>

Thanks! Good to know!

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [August 24, 2022, 12:52pm UTC](https://community.glideapps.com/t/if-this-and-that-then/47626/4 "2022-08-24T12:52:34Z")

</div>

> [@Better and more consistent IF THEN logic](https://community.glideapps.com/t/better-and-more-consistent-if-then-logic/24317):
>
> 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…

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [August 25, 2022, 12:53pm UTC](https://community.glideapps.com/t/if-this-and-that-then/47626/5 "2022-08-25T12:53:11Z")

</div>

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