# Email Column is populating in one sheet but not in other sheet

**URL:** <https://community.glideapps.com/t/email-column-is-populating-in-one-sheet-but-not-in-other-sheet/39546>\
**Category:** Ask for Help\
**Created:** [March 12, 2022, 6:17am UTC](https://community.glideapps.com/t/email-column-is-populating-in-one-sheet-but-not-in-other-sheet/39546 "2022-03-12T06:17:53Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [March 12, 2022, 6:17am UTC](https://community.glideapps.com/t/email-column-is-populating-in-one-sheet-but-not-in-other-sheet/39546/1 "2022-03-12T06:17:53Z")

</div>

While i was testing yesterday i have realised that we have assigned default values to the number entry source column in the google sheets, you can see in the screenshot,

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/2/a2ad963135cc91b5377faaf41bc15fefcefd48e5.png)

that all the fields are already populated and waiting for the user to login in, **so the strange issue i figured out that** , as soon as the email column gets populated, then all the values gets visible to the user, but there is a catch, we have created two sheets for the new user i.e. **1. User Profiles 2. New User** , so we have used **User Profile** sheet for flagging, and controlling other features, and the **New User** sheet is where all the other values are stored, Now as soon as the user logs in, the email column in the user profile sheet in glide updates after 5-6 seconds .

For the email column in **New User** sheet, I have formed a relation and have used lookup column between the **User Profiles** and **New User** , but then also the email column is not updating. Any thoughts about, how can we approach for this issue. You can see what is happening through this video: **[[bandicam 2022-03-12 11-27-10-376.mp4 - Google Drive](https://drive.google.com/file/d/1iKyFGIYm1_KLpp5TRLkNCQCIsXjo08ps/view?usp=sharing)]**

**Issue:** Even though i have formed a relation between both the sheets, and have used lookup, the also **the email column is not populating in New User sheet but populating in User Profile sheet.**

---

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [March 12, 2022, 6:47am UTC](https://community.glideapps.com/t/email-column-is-populating-in-one-sheet-but-not-in-other-sheet/39546/2 "2022-03-12T06:47:03Z")

</div>

How to get data from one sheet to another sheet, if there are no similar column/s between both the sheet where we can form a relation?.

---

<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:** [March 12, 2022, 11:24pm UTC](https://community.glideapps.com/t/email-column-is-populating-in-one-sheet-but-not-in-other-sheet/39546/3 "2022-03-12T23:24:02Z")

</div>

> [@Th.Nitin](#):
>
> that all the fields are already populated and waiting for the user to login in, **so the strange issue i figured out that** , as soon as the email column gets populated, then all the values gets visible to the user, but there is a catch, we have created two sheets for the new user i.e. **1. User Profiles 2. New User** , so we have used **User Profile** sheet for flagging, and controlling other features, and the **New User** sheet is where all the other values are stored

Can you explain why do you need 2 sheets for this?

> [@Th.Nitin](#):
>
> For the email column in **New User** sheet, I have formed a relation and have used lookup column between the **User Profiles** and **New User**

How are you creating the relation?

Ultimately, I feel like the approach here can be improved, I’m still not sure why you have to use 2 sheets for this.
