# Google Sheets and ARRAYFORMULA

**URL:** <https://community.glideapps.com/t/google-sheets-and-arrayformula/51609>\
**Category:** Ask for Help\
**Created:** [October 12, 2022, 11:16pm UTC](https://community.glideapps.com/t/google-sheets-and-arrayformula/51609 "2022-10-12T23:16:27Z")\
**Posts on this page:** 3\
**Page:** 2

<div class="post-metadata">

**Author:** ![burningmikey](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/burningmikey/32/49706_2.png) [@burningmikey](https://community.glideapps.com/u/burningmikey)\
**Post date:** [July 13, 2023, 3:45pm UTC](https://community.glideapps.com/t/google-sheets-and-arrayformula/51609/22 "2023-07-13T15:45:05Z")

</div>

I agree. The only reason I use a Sheet formula is to create a mirror public table (no row owners) from a private table (row owners). Unless there is another way to do it!

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [July 13, 2023, 4:19pm UTC](https://community.glideapps.com/t/google-sheets-and-arrayformula/51609/23 "2023-07-13T16:19:24Z")

</div>

Of course there is 😉

> [@locked\_with\_key Secure Your Data with Row Owners and Public Profiles](https://community.glideapps.com/t/secure-your-data-with-row-owners-and-public-profiles/52139):
>
> wave Hey fellow Gliders! Are you using Row Owners and Public Profiles to secure your user data? If not, you might accidentally expose private info. Let’s fix that. In this important tutorial, I demonstrate how and why to enable Row Owners, create a Public Profiles table, and onboard new users in order to safely create a community app that doesn’t reference the User Profile table. [[Glide: Secure Your Data with Row Owners and Public Profiles] ](https://www.youtube.com/watch?v=JPgZeDSPQMw) You can also reference this article in…

---

<div class="post-metadata">

**Author:** ![burningmikey](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/burningmikey/32/49706_2.png) [@burningmikey](https://community.glideapps.com/u/burningmikey)\
**Post date:** [July 13, 2023, 5:10pm UTC](https://community.glideapps.com/t/google-sheets-and-arrayformula/51609/24 "2023-07-13T17:10:37Z")

</div>

Much more better and elegant. I had missed that video, so thank you 😀

[Previous page](https://community.glideapps.com/t/google-sheets-and-arrayformula/51609.md?page=1)