# How do I use If..then conditions on Excel datasource for developing custom filters?

**URL:** <https://community.glideapps.com/t/how-do-i-use-if-then-conditions-on-excel-datasource-for-developing-custom-filters/65897>\
**Category:** Ask for Help\
**Created:** [September 7, 2023, 11:00pm UTC](https://community.glideapps.com/t/how-do-i-use-if-then-conditions-on-excel-datasource-for-developing-custom-filters/65897 "2023-09-07T23:00:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![chandlers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chandlers/32/54972_2.png) [@chandlers](https://community.glideapps.com/u/chandlers)\
**Post date:** [September 7, 2023, 11:00pm UTC](https://community.glideapps.com/t/how-do-i-use-if-then-conditions-on-excel-datasource-for-developing-custom-filters/65897/1 "2023-09-07T23:00:31Z")

</div>

I would like to use custom filters on an Excel datasource. However, the ‘If then’ conditions are only available on the glide table. Please guide!

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [September 8, 2023, 1:31am UTC](https://community.glideapps.com/t/how-do-i-use-if-then-conditions-on-excel-datasource-for-developing-custom-filters/65897/2 "2023-09-08T01:31:16Z")

</div>

> [@chandlers](#):
>
> However, the ‘If then’ conditions are only available on the glide table

It doesn’t sound right. You should be available to use computed columns like If-Then-Else on any data sources. Can you attach a screenshot?

---

<div class="post-metadata">

**Author:** ![chandlers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chandlers/32/54972_2.png) [@chandlers](https://community.glideapps.com/u/chandlers)\
**Post date:** [September 8, 2023, 2:57pm UTC](https://community.glideapps.com/t/how-do-i-use-if-then-conditions-on-excel-datasource-for-developing-custom-filters/65897/3 "2023-09-08T14:57:17Z")

</div>

I see the option now under, ‘Computed’, ‘If → Then → Else’.  
Thanks for your support!

---

<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:** [September 15, 2023, 2:57pm UTC](https://community.glideapps.com/t/how-do-i-use-if-then-conditions-on-excel-datasource-for-developing-custom-filters/65897/4 "2023-09-15T14:57:56Z")

</div>

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