# Any way to create a relation between the App:Comments sheet and another?

**URL:** <https://community.glideapps.com/t/any-way-to-create-a-relation-between-the-app-comments-sheet-and-another/38971>\
**Category:** Ask for Help\
**Created:** [February 25, 2022, 9:15pm UTC](https://community.glideapps.com/t/any-way-to-create-a-relation-between-the-app-comments-sheet-and-another/38971 "2022-02-25T21:15:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Butter-Bee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/butter-bee/32/15102_2.png) [@Butter-Bee](https://community.glideapps.com/u/Butter-Bee)\
**Post date:** [February 25, 2022, 9:15pm UTC](https://community.glideapps.com/t/any-way-to-create-a-relation-between-the-app-comments-sheet-and-another/38971/1 "2022-02-25T21:15:55Z")

</div>

I’d love to be able to display the number of comments that a specific ‘topic’ has associated with it! Given that, is there any way to create a relation between the App:Comments sheet and another?

---

<div class="post-metadata">

**Author:** ![Killko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/killko/32/39538_2.png) [@Killko](https://community.glideapps.com/u/Killko)\
**Post date:** [February 25, 2022, 9:29pm UTC](https://community.glideapps.com/t/any-way-to-create-a-relation-between-the-app-comments-sheet-and-another/38971/2 "2022-02-25T21:29:13Z")

</div>

I never tried, but I assume you could create a column in GSheets with a Vlookup…

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [February 25, 2022, 9:37pm UTC](https://community.glideapps.com/t/any-way-to-create-a-relation-between-the-app-comments-sheet-and-another/38971/3 "2022-02-25T21:37:31Z")

</div>

I think the easiest way to do this is to create a copy of the App:comments sheet using an array formula in another sheet. This way, Glide will see this new sheet and you’ll be able to reference it in your app.

---

<div class="post-metadata">

**Author:** ![Butter-Bee](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/butter-bee/32/15102_2.png) [@Butter-Bee](https://community.glideapps.com/u/Butter-Bee)\
**Post date:** [February 25, 2022, 9:44pm UTC](https://community.glideapps.com/t/any-way-to-create-a-relation-between-the-app-comments-sheet-and-another/38971/4 "2022-02-25T21:44:05Z")

</div>

Yes thank you! I was just poking around on other similar threads and found this solution. Note to others this will eat into the number of columns you app can use.

**But here’s the exact array formula that works:**  
=ARRAYFORMULA(IF(‘App: Comments’!A1:F=“”,“”,‘App: Comments’!A1:F))

**Source:**

> [@Show comments in a list](https://community.glideapps.com/t/show-comments-in-a-list/25398/6):
>
> You can use an arrayformula. Something like this: =ARRAYFORMULA(IF('App: Comments'!A1:F="","",'App: Comments'!A1:F))

Thanks @Darren_Murphy

---

<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:** [February 26, 2022, 9:44pm UTC](https://community.glideapps.com/t/any-way-to-create-a-relation-between-the-app-comments-sheet-and-another/38971/5 "2022-02-26T21:44:40Z")

</div>

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