# 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:** 3
**Page:** 1

<div class="post-metadata">

### Author: ![Deena](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/deena/32/9877_2.png) [@Deena](https://community.glideapps.com/u/Deena)
#### Post date: [September 25, 2020, 1:42am UTC](https://community.glideapps.com/t/can-array-formulas-be-done-in-the-glide-sheets/16341/1 "2020-09-25T01:42:33Z")

</div>

Sorry if I missed this in a prior thread. I haven’t been focused on the Glide sheets discussions. Specifically referring to this:

> **[Glide Docs](https://www.glideapps.com/docs)**
>
> Welcome to Glide Docs, a steadily growing collection of articles and videos on how to use Glide. We can’t wait to see what you build!

Like creating an image carousel.

---

<div class="post-metadata">

### Author: ![Wiz.Wazeer](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wiz.wazeer/32/72423_2.png) [@Wiz.Wazeer](https://community.glideapps.com/u/Wiz.Wazeer)
#### Post date: [September 25, 2020, 2:15am UTC](https://community.glideapps.com/t/can-array-formulas-be-done-in-the-glide-sheets/16341/2 "2020-09-25T02:15:32Z")

</div>

Sorry, array formulas or columns?

Formulas, no.  
image carousel, yes but requires some work. You can find it all here

> [@new Glide Tables](https://community.glideapps.com/t/glide-tables/15597/77):
>
> Thanks @Wiz.Wazeer! A question on private chat. Let’s say I’ve set-up a sort of forum (‘adapting’ @Robert_Petitto template which was much too smart for me :-)) ; it’s based upon a form to create a topic inline list to display topics inside the inline list item there is a ‘Comments’ component =\> In each item of the inline list, in addition to the ‘Comments’ component (which is visible by anybody using the forum), do you think that we can add a one-to-one ‘chat’? it would enable direct messag…

---

<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
