# Copy relations when using ARRAYFORMULA

**URL:** https://community.glideapps.com/t/copy-relations-when-using-arrayformula/8408
**Category:** Ask for Help
**Created:** [May 3, 2020, 9:08pm UTC](https://community.glideapps.com/t/copy-relations-when-using-arrayformula/8408 "2020-05-03T21:08:39Z")
**Posts on this page:** 6
**Page:** 1

<div class="post-metadata">

### Author: ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)
#### Post date: [May 3, 2020, 9:08pm UTC](https://community.glideapps.com/t/copy-relations-when-using-arrayformula/8408/1 "2020-05-03T21:08:39Z")

</div>

Hey,

I saw Jeff using this function to use the same data for a different view with different components.  
Seems like I have to copy all the relations and lookups manually from the other sheet.

Am I doing something wrong?

---

<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: [May 4, 2020, 3:07am UTC](https://community.glideapps.com/t/copy-relations-when-using-arrayformula/8408/2 "2020-05-04T03:07:29Z")

</div>

Hi Leon, can you point us to the specific post that Jeff used that, and describe more about your use case as well.

---

<div class="post-metadata">

### Author: ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)
#### Post date: [May 4, 2020, 11:49am UTC](https://community.glideapps.com/t/copy-relations-when-using-arrayformula/8408/3 "2020-05-04T11:49:53Z")

</div>

[![](https://img.youtube.com/vi/B8ivh42ZqVA/hqdefault.jpg "Make Your Own Instagram with Glide | Glide Apps") ](https://www.youtube.com/watch?v=B8ivh42ZqVA)

---

<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: [May 4, 2020, 1:03pm UTC](https://community.glideapps.com/t/copy-relations-when-using-arrayformula/8408/4 "2020-05-04T13:03:53Z")

</div>

No you aren’t doing anything wrong. In that case it’s a new sheet, so yes, you would have to recreate any Glide relation and lookup columns for the new sheet that you had in the old sheet.

---

<div class="post-metadata">

### Author: ![Leon\_Kol](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/leon_kol/32/6488_2.png) [@Leon\_Kol](https://community.glideapps.com/u/Leon_Kol)
#### Post date: [May 4, 2020, 5:43pm UTC](https://community.glideapps.com/t/copy-relations-when-using-arrayformula/8408/5 "2020-05-04T17:43:43Z")

</div>

So maybe its better to use the old sheet?

Or its a must? because if not, glide will copy the same components and if i edit it will change in the other view was connect to this sheet?(one view per sheet)

Thanks Jeff!!!

---

<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: [May 4, 2020, 7:04pm UTC](https://community.glideapps.com/t/copy-relations-when-using-arrayformula/8408/6 "2020-05-04T19:04:19Z")

</div>

Like I always say, detail layouts are tied to sheets and each sheet can have it’s own layout. If you need to view the same data in different ways, then you need different sheets. The only exception to that rule is the very top level of a tab or Link to Screen action. In that case, a detail layout can be unique, but only at that top level. If you are drilling down into a list, then the details layout from that list item is shared across the app. It all comes down to your specific scenario and what you need.

Just keep in mind that if you do copy the sheet, you will not be able to edit it.