# Anyone know how to auto-populate columns btw sheets

**URL:** <https://community.glideapps.com/t/anyone-know-how-to-auto-populate-columns-btw-sheets/17359>\
**Category:** Ask for Help\
**Created:** [October 20, 2020, 2:33pm UTC](https://community.glideapps.com/t/anyone-know-how-to-auto-populate-columns-btw-sheets/17359 "2020-10-20T14:33:44Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\
**Post date:** [October 20, 2020, 2:33pm UTC](https://community.glideapps.com/t/anyone-know-how-to-auto-populate-columns-btw-sheets/17359/1 "2020-10-20T14:33:44Z")

</div>

Hi! Does anyone know how the formula to auto-populate info from a column in one sheet to a column in another sheet in Google Sheets? Not the entire sheet, just one column - like Sheet 1 column A auto-populates to Sheet 2 column A. Someone gave me a formula =if(Sheet1!A1\<\>“”,Sheet2!A1,“”) but it doesn’t work. Thanks!

---

<div class="post-metadata">

**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\
**Post date:** [October 20, 2020, 2:41pm UTC](https://community.glideapps.com/t/anyone-know-how-to-auto-populate-columns-btw-sheets/17359/2 "2020-10-20T14:41:35Z")

</div>

Depending on scenario you can use computed columns as Lookup or Single Value to transfer values from one sheet to another.

> **[Lookup Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/lookup-column)**
>
> Lookup values from another table

> **[Single Value Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/single-value-column)**
>
> Copy a single value to every row

Hope it helps.

---

<div class="post-metadata">

**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\
**Post date:** [October 20, 2020, 2:49pm UTC](https://community.glideapps.com/t/anyone-know-how-to-auto-populate-columns-btw-sheets/17359/3 "2020-10-20T14:49:14Z")

</div>

Thank you, but I should have mentioned that I wanted to do it in Google sheets, not within the Glide platform. I’ll update my question.

---

<div class="post-metadata">

**Author:** ![darder](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darder/32/12788_2.png) [@darder](https://community.glideapps.com/u/darder)\
**Post date:** [October 20, 2020, 2:58pm UTC](https://community.glideapps.com/t/anyone-know-how-to-auto-populate-columns-btw-sheets/17359/4 "2020-10-20T14:58:55Z")

</div>

Ok

I think this should be possible using an Array Formula but it is not my forte.

---

<div class="post-metadata">

**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\
**Post date:** [October 20, 2020, 3:00pm UTC](https://community.glideapps.com/t/anyone-know-how-to-auto-populate-columns-btw-sheets/17359/5 "2020-10-20T15:00:39Z")

</div>

Thanks… @darder

@ThinhDinh do you know of a formula that can help me do this?

---

<div class="post-metadata">

**Author:** ![Robert\_Petitto](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/robert_petitto/32/25193_2.png) [@Robert\_Petitto](https://community.glideapps.com/u/Robert_Petitto)\
**Post date:** [October 20, 2020, 3:06pm UTC](https://community.glideapps.com/t/anyone-know-how-to-auto-populate-columns-btw-sheets/17359/6 "2020-10-20T15:06:16Z")

</div>

Needs to be more like this:

```auto
={"Copied Column";ARRAYFORMULA(IF(LEN('Sheet1'!A1:A),'Sheet1'!A1:A,""))}

```

Copy this and paste in Row 1 of whatever column you’d like within the second sheet.

---

<div class="post-metadata">

**Author:** ![Dr\_Renee\_Volny\_Darko](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/dr_renee_volny_darko/32/4492_2.png) [@Dr\_Renee\_Volny\_Darko](https://community.glideapps.com/u/Dr_Renee_Volny_Darko)\
**Post date:** [October 20, 2020, 3:54pm UTC](https://community.glideapps.com/t/anyone-know-how-to-auto-populate-columns-btw-sheets/17359/7 "2020-10-20T15:54:49Z")

</div>

Thank you soooo much!!!