# How can you auto fill a cell with a default value?
**URL:** https://community.glideapps.com/t/how-can-you-auto-fill-a-cell-with-a-default-value/8070
**Category:** Ask for Help
**Created:** [April 29, 2020, 7:03am UTC](https://community.glideapps.com/t/how-can-you-auto-fill-a-cell-with-a-default-value/8070 "2020-04-29T07:03:35Z")
**Posts on this page:** 5
**Page:** 1
### Author:  [@ray\_d](https://community.glideapps.com/u/ray_d)
#### Post date: [April 29, 2020, 7:03am UTC](https://community.glideapps.com/t/how-can-you-auto-fill-a-cell-with-a-default-value/8070/1 "2020-04-29T07:03:35Z")
Hi, I’m trying to create an approval system for an Admin to approve or deny new user submissions.
I saw in one of the Glide tutorials that you can do this by creating an Admin column in your sheet and assign your email as Admin, then also add a boolean switch to the app to control Publish status that is visible only to Admins.
The only problem is I have to manually add myself as admin on each new entry’s row in the sheet. If I try to pre-populate the entire Admin column in the sheet with my email, the new user submitted entry will just jump to the next empty row which will not have my email inputted as Admin.
My question is: **What is a formula I can use to automatically input my email in the Admin cell for each new submission row in the sheet?** I’ve been scouring the web, but I can’t find a way to make it work. I have a feeling it has to do with `=ARRAYFORMULA(A2:A, "my@email.com")` but that doesn’t seem to work.
Anyone know how to do this?
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 29, 2020, 7:51am UTC](https://community.glideapps.com/t/how-can-you-auto-fill-a-cell-with-a-default-value/8070/2 "2020-04-29T07:51:20Z")
Each new submission row, let’s say it goes in the column A, then you can input in column B.
=ARRAYFORMULA(IF(A2:A\<\>"","my@email.com",""))
This checks if any cells from A2 to the end of column A is not null, if it’s not null, the value [my@email.com](mailto:my@email.com) will be set to column B, else it’s left empty.
---
### Author:  [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)
#### Post date: [April 29, 2020, 10:29am UTC](https://community.glideapps.com/t/how-can-you-auto-fill-a-cell-with-a-default-value/8070/3 "2020-04-29T10:29:23Z")
@ThinhDinh is correct. However, more recently, I just create a template column in Glide, call it Admin, and then enter `admin` in the enter value box. No formulas needed!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [April 29, 2020, 11:25am UTC](https://community.glideapps.com/t/how-can-you-auto-fill-a-cell-with-a-default-value/8070/4 "2020-04-29T11:25:17Z")
That is great!
---
### Author:  [@ray\_d](https://community.glideapps.com/u/ray_d)
#### Post date: [April 29, 2020, 6:54pm UTC](https://community.glideapps.com/t/how-can-you-auto-fill-a-cell-with-a-default-value/8070/5 "2020-04-29T18:54:22Z")
This is awesome! Thank you both!