# Constant Role Assignment That Works Like a Glide Template Column!

**URL:** <https://community.glideapps.com/t/constant-role-assignment-that-works-like-a-glide-template-column/78028>\
**Category:** Community Resources\
**Tags:** row-owners\
**Created:** [November 19, 2024, 6:19pm UTC](https://community.glideapps.com/t/constant-role-assignment-that-works-like-a-glide-template-column/78028 "2024-11-19T18:19:06Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [November 19, 2024, 6:19pm UTC](https://community.glideapps.com/t/constant-role-assignment-that-works-like-a-glide-template-column/78028/1 "2024-11-19T18:19:06Z")

</div>

Hey Glide enthusiasts! I’ve found a super useful **ArrayFormula** in Google Sheet that mimics a **template column** but with a twist. It is stored in a **basic column** , so it works perfectly with **Row Owners**!

Here is the magic formula:  
Edit:

> [@ThinhDinh](#):
>
> ```auto
> ={"Admin Access";ARRAYFORMULA(IF(A2:A <> "", "Admin", ""))}
> 
> ```
> 
> This is assuming you will always have data in column A.

Original:

```auto
=ARRAYFORMULA(IF(A1:A <> ""; IF(ROW(A1:A) = 1; "Admin Access"; "Admin"); ""))

```

### ✨ Why this is awesome:

- The first row always gets **“Admin Access”** , making it stand out.
- All other rows are automatically labeled as **“Admin”** for consistency.
- Blank rows stay blank to keep your data tidy.
- Since it’s in a **basic column** , it plays nicely with **Row Owners** , ensuring your data stays secure!

### ⚠ Important:

Don’t edit this column directly from the Glide Data Editor—let the formula handle everything in your spreadsheet to avoid breaking the setup.

Try it out and let me know how it helps you! 🙌

---

<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:** [November 20, 2024, 12:58am UTC](https://community.glideapps.com/t/constant-role-assignment-that-works-like-a-glide-template-column/78028/2 "2024-11-20T00:58:30Z")

</div>

I usually do it like this.

```auto
={"Admin Access";ARRAYFORMULA(IF(A2:A <> "", "Admin", ""))}

```

This is assuming you will always have data in column A.

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [November 20, 2024, 1:45am UTC](https://community.glideapps.com/t/constant-role-assignment-that-works-like-a-glide-template-column/78028/3 "2024-11-20T01:45:07Z")

</div>

Yours is better!

---

<div class="post-metadata">

**Author:** ![NFNHello](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nfnhello/32/3371_2.png) [@NFNHello](https://community.glideapps.com/u/NFNHello)\
**Post date:** [November 20, 2024, 2:08am UTC](https://community.glideapps.com/t/constant-role-assignment-that-works-like-a-glide-template-column/78028/4 "2024-11-20T02:08:52Z")

</div>

Be careful not to allow a user to delete that first row through the app interface. 🌠

---

<div class="post-metadata">

**Author:** ![MaximeBaker](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/maximebaker/32/80877_2.png) [@MaximeBaker](https://community.glideapps.com/u/MaximeBaker)\
**Post date:** [November 20, 2024, 2:59am UTC](https://community.glideapps.com/t/constant-role-assignment-that-works-like-a-glide-template-column/78028/5 "2024-11-20T02:59:34Z")

</div>

Actually, no cell in that column should be removed:  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/e/2e55bca09b8adbe30d7dedf870cd0e45f19f98a3.png)

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/902b926f19a6b3593f13db495f5fe7a427676fb4.png)