# Formula field like in Airtable

**URL:** <https://community.glideapps.com/t/formula-field-like-in-airtable/64507>\
**Category:** Feature Requests\
**Created:** [July 30, 2023, 7:46am UTC](https://community.glideapps.com/t/formula-field-like-in-airtable/64507 "2023-07-30T07:46:26Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\
**Post date:** [July 30, 2023, 7:46am UTC](https://community.glideapps.com/t/formula-field-like-in-airtable/64507/1 "2023-07-30T07:46:27Z")

</div>

It would be great to have a formula column like in Airtable, in order to be able to create in one column different scenarios using " if else " and other types of expressions, operators and formulas with Glide Tables.

---

<div class="post-metadata">

**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\
**Post date:** [July 30, 2023, 9:06am UTC](https://community.glideapps.com/t/formula-field-like-in-airtable/64507/2 "2023-07-30T09:06:48Z")

</div>

Like this 👇

> **[Glide • If → Then → Else Column](https://www.glideapps.com/docs/reference/computed-columns/if-then-else-column)**
>
> Produce different values based on conditions.

---

<div class="post-metadata">

**Author:** ![Ovi](https://avatars.discourse-cdn.com/v4/letter/o/3ab097/32.png) [@Ovi](https://community.glideapps.com/u/Ovi)\
**Post date:** [July 30, 2023, 9:41am UTC](https://community.glideapps.com/t/formula-field-like-in-airtable/64507/3 "2023-07-30T09:41:19Z")

</div>

@Rosewebstudio That works but in order to achieve something like A - B where you don’t know if the B value exists, you would have to create around 3 columns … if a formula field would be available, you would only need one.

---

<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:** [July 30, 2023, 3:48pm UTC](https://community.glideapps.com/t/formula-field-like-in-airtable/64507/4 "2023-07-30T15:48:33Z")

</div>

Do you have a real world example? You can do a lot with an IF column, but sometimes you have to think creatively to get it right.

If all else fails, you still have a javascript column that can do much more complex comparisons.

---

<div class="post-metadata">

**Author:** ![Laurent\_Maleville](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/laurent_maleville/32/8643_2.png) [@Laurent\_Maleville](https://community.glideapps.com/u/Laurent_Maleville)\
**Post date:** [July 30, 2023, 3:49pm UTC](https://community.glideapps.com/t/formula-field-like-in-airtable/64507/5 "2023-07-30T15:49:50Z")

</div>

Or like that

> **[Glide • Query Column](https://www.glideapps.com/docs/reference/computed-columns/query-column)**
>
> Create complex relations in your data with conditional filtering, sorting and limits.

---

<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 12, 2023, 1:52am UTC](https://community.glideapps.com/t/formula-field-like-in-airtable/64507/6 "2023-08-12T01:52:42Z")

</div>

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