# Can array formulas be done in the Glide sheets?

**URL:** <https://community.glideapps.com/t/can-array-formulas-be-done-in-the-glide-sheets/16341>\
**Category:** Ask for Help\
**Created:** [September 25, 2020, 1:42am UTC](https://community.glideapps.com/t/can-array-formulas-be-done-in-the-glide-sheets/16341 "2020-09-25T01:42:33Z")\
**Posts on this page:** 1\
**Showing post:** 3

<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:** [September 25, 2020, 3:44am UTC](https://community.glideapps.com/t/can-array-formulas-be-done-in-the-glide-sheets/16341/3 "2020-09-25T03:44:43Z")

</div>

Yeah, same question…array columns or arrayformulas. Those are not related.

Any glide-only columns is essentially an arrayformula column because it applies the same logic to each row.

Arrays can be achieved in several different ways. A lookup from a multiple relation is an array (each matching row in a lookup is a row that’s converted into an array). If you want to create an array from multiple columns in the glide sheet, then this thread should help.

> [@BUG - glide table not creating array colum for emails](https://community.glideapps.com/t/bug-glide-table-not-creating-array-colum-for-emails/16257):
>
> Hi Glide team, @Mark @Jason I created several columns for emails one next to the other with the header “created by 1”…“Created by 2”… until 4. when I’m trying to set the filter for a choiche component to created by is signed in user I don’t get an array column of created by to set to all of them togethr: all the columns are set as email in the glide table and I even created fake row that is full with emails

---

_[View the full topic](https://community.glideapps.com/t/can-array-formulas-be-done-in-the-glide-sheets/16341)._