# Array formula in Google Sheet

**URL:** <https://community.glideapps.com/t/array-formula-in-google-sheet/51377>\
**Category:** Ask for Help\
**Created:** [October 10, 2022, 9:35am UTC](https://community.glideapps.com/t/array-formula-in-google-sheet/51377 "2022-10-10T09:35:25Z")\
**Posts on this page:** 1\
**Showing post:** 4

<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:** [October 11, 2022, 8:55am UTC](https://community.glideapps.com/t/array-formula-in-google-sheet/51377/4 "2022-10-11T08:55:06Z")

</div>

The below might be of interest.

> [@How To: Use a Public Users table to keep private user data secure (Glide Tables only)](https://community.glideapps.com/t/how-to-use-a-public-users-table-to-keep-private-user-data-secure-glide-tables-only/51391):
>
> Here is a copyable concept App that demonstrates how to keep User Profile data secure through the use of Row Owners, and at the same time share a subset of each users data via a Public Users table, using Glide Tables only Key points: A simple onboarding screen forces new users to complete their basic profile information. When a user completes the onboarding, their Public Profile is created The Users table and Public Users table are kept in sync by using an onSubmit action on the User Profile …

---

_[View the full topic](https://community.glideapps.com/t/array-formula-in-google-sheet/51377)._
