# App Logins to two sheets

**URL:** <https://community.glideapps.com/t/app-logins-to-two-sheets/9507>\
**Category:** Ask for Help\
**Created:** [May 20, 2020, 8:14pm UTC](https://community.glideapps.com/t/app-logins-to-two-sheets/9507 "2020-05-20T20:14:16Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\
**Post date:** [May 20, 2020, 8:14pm UTC](https://community.glideapps.com/t/app-logins-to-two-sheets/9507/1 "2020-05-20T20:14:16Z")

</div>

Loving Glide  
I am quite OK now with the having the email addresses going from App logins automaticaly (no idea how this works!) to sheet one and creating a new line for each new subscriber. I have an app that now has abour 35 columns and is getting a bit difficult to work with.  
Is it possible to have the email address from the App logins go to sheet two as well ?

Thanks

---

<div class="post-metadata">

**Author:** ![Mauricio\_Paz](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mauricio_paz/32/17751_2.png) [@Mauricio\_Paz](https://community.glideapps.com/u/Mauricio_Paz)\
**Post date:** [May 20, 2020, 10:43pm UTC](https://community.glideapps.com/t/app-logins-to-two-sheets/9507/2 "2020-05-20T22:43:30Z")

</div>

Of course, it is possible with this formula:

> = ARRAYFORMULA (‘App: Logins’! B: B)

App: Logins is the sheet where your session login is, select the column where the email addresses are located.

You can also use it with more than two columns to a different spreadsheet, just select the range of columns, for example:

> = ARRAYFORMULA (‘App: Logins’! B: Z)

---

<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:** [May 20, 2020, 11:48pm UTC](https://community.glideapps.com/t/app-logins-to-two-sheets/9507/3 "2020-05-20T23:48:07Z")

</div>

To add to what Mauricio has said, it’s possible to create an array of only columns you want to. It would look like.

```
=ARRAYFORMULA({'App: Logins'!A:A,'App: Logins'!C:C,'App: Logins'!Z:Z})

```

You can throw an IF into that formula as well to check if the row is filled with the data.

---

<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:** [May 20, 2020, 11:50pm UTC](https://community.glideapps.com/t/app-logins-to-two-sheets/9507/4 "2020-05-20T23:50:38Z")

</div>

Hi Mike! The user profiles feature takes care of this for you without array formulas

[User Specific Columns + User Profiles Demo](https://community.glideapps.com/t/user-specific-columns-user-profiles-demo/7097)

Or

[Our Chores v1.0: An app that lets you manage and track your child(ren)'s chores](https://community.glideapps.com/t/our-chores-v1-0-an-app-that-lets-you-manage-and-track-your-child-ren-s-chores/7536)

---

<div class="post-metadata">

**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\
**Post date:** [May 21, 2020, 6:53am UTC](https://community.glideapps.com/t/app-logins-to-two-sheets/9507/5 "2020-05-21T06:53:26Z")

</div>

Many thanks  
Mike

---

<div class="post-metadata">

**Author:** ![Mike\_Greene](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mike_greene/32/5942_2.png) [@Mike\_Greene](https://community.glideapps.com/u/Mike_Greene)\
**Post date:** [May 21, 2020, 1:59pm UTC](https://community.glideapps.com/t/app-logins-to-two-sheets/9507/6 "2020-05-21T13:59:23Z")

</div>

Thanks Robert  
I’ve watched your video once - I need to watch it again - and then play with it !  
Mike