# Double If condition

**URL:** <https://community.glideapps.com/t/double-if-condition/56243>\
**Category:** Ask for Help\
**Created:** [January 2, 2023, 5:33pm UTC](https://community.glideapps.com/t/double-if-condition/56243 "2023-01-02T17:33:24Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Erick](https://avatars.discourse-cdn.com/v4/letter/e/bbce88/32.png) [@Erick](https://community.glideapps.com/u/Erick)\
**Post date:** [January 2, 2023, 5:33pm UTC](https://community.glideapps.com/t/double-if-condition/56243/1 "2023-01-02T17:33:24Z")

</div>

Hi there

In a table I ve a column with the end date of the project. I’ve also an other table with the project phase.  
If the Date is before today AND the Phase in not ‘Completed’ … then I would like to display ‘Delayed’.

Is it possible ?  
It seems that it is not possible to make AND conditions ?  
Best regards  
Erick

---

<div class="post-metadata">

**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\
**Post date:** [January 2, 2023, 6:22pm UTC](https://community.glideapps.com/t/double-if-condition/56243/3 "2023-01-02T18:22:48Z")

</div>

you have and or conditions in filters… in the IF-ELSE column you need to use a trick… make the order of conditions, the way that will eliminate nontrue options… so in your case, it will be:  
if date is on after =\> 0  
if phase is completed =\> 0  
else 1

so the result will be 1 if the date is before and is not completed.

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [January 2, 2023, 6:27pm UTC](https://community.glideapps.com/t/double-if-condition/56243/4 "2023-01-02T18:27:40Z")

</div>

- if date is on or after today, then null (empty)
- if phase is completed, then null
- else Delayed

---

<div class="post-metadata">

**Author:** ![Erick](https://avatars.discourse-cdn.com/v4/letter/e/bbce88/32.png) [@Erick](https://community.glideapps.com/u/Erick)\
**Post date:** [January 2, 2023, 10:52pm UTC](https://community.glideapps.com/t/double-if-condition/56243/6 "2023-01-02T22:52:27Z")

</div>

Thank You very much Uzo

Perfect solution !

Best regards

Erick

 ![image001.jpg](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/dbc144d307f3ebdbd6d32f447df587ff3da9e6da.jpeg)

---

<div class="post-metadata">

**Author:** ![Erick](https://avatars.discourse-cdn.com/v4/letter/e/bbce88/32.png) [@Erick](https://community.glideapps.com/u/Erick)\
**Post date:** [January 2, 2023, 10:53pm UTC](https://community.glideapps.com/t/double-if-condition/56243/7 "2023-01-02T22:53:22Z")

</div>

Thx !

 ![image001.jpg](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/b/dbc144d307f3ebdbd6d32f447df587ff3da9e6da.jpeg)