# How Can i get data from other sheet without relation and lookup columns **URL:** \ **Category:** Ask for Help\ **Created:** [March 12, 2022, 9:20am UTC](https://community.glideapps.com/t/how-can-i-get-data-from-other-sheet-without-relation-and-lookup-columns/39547 "2022-03-12T09:20:06Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![rahul482](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rahul482](https://community.glideapps.com/u/rahul482)\ **Post date:** [March 12, 2022, 9:20am UTC](https://community.glideapps.com/t/how-can-i-get-data-from-other-sheet-without-relation-and-lookup-columns/39547/1 "2022-03-12T09:20:06Z")
In my glide app, there is one spreadsheet and i have created another empty glide sheet, now i want the entire email column from the spreadsheet into the newly created glide sheet. Since i have no columns or data in the new glide sheet, i want first column to be email, how can i get the entire email column without using relation & lookup.? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 12, 2022, 9:27am UTC](https://community.glideapps.com/t/how-can-i-get-data-from-other-sheet-without-relation-and-lookup-columns/39547/2 "2022-03-12T09:27:22Z")
I could make some suggestions, but before I do could you explain more about your use case? Specifically, what is the ultimate purpose of this new Glide Table? Is the intention to use it as your User Profiles table, or something else? Is this just a once-off copy/transfer of data that you need to do, or should it dynamically update with each new user? ---
**Author:** ![rahul482](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rahul482](https://community.glideapps.com/u/rahul482)\ **Post date:** [March 12, 2022, 1:44pm UTC](https://community.glideapps.com/t/how-can-i-get-data-from-other-sheet-without-relation-and-lookup-columns/39547/3 "2022-03-12T13:44:45Z")
**It should dynamically update with each user type, so i can differentiate the data for new user, based on their email id.** **Use Case** : As you can see in the screenshot I have created a new sheet(which I will use it in future) called investment portfolio. And as per the user type i want to differentiate the investments data using email id, i want email id column to populate at the same time as the user profile does. In future I will assign some default values to other columns so as soon as the new user logs in the email col get populated and the glide can show data depending on the user email id. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/2/22459d9c1367459d4bcb79746e3e1c00ec2f8825.png) ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 12, 2022, 2:07pm UTC](https://community.glideapps.com/t/how-can-i-get-data-from-other-sheet-without-relation-and-lookup-columns/39547/4 "2022-03-12T14:07:57Z")
Okay, so here is one suggestion. - Firstly, you will need to manually add rows to this table - at least as many as you have in your user profiles table. - Create a RowID column - Create a Lookup column, that targets the RowID column. This will give you an array of all RowIDs - Create an Array → Find Element Index column. This should look for the RowID in the array of RowIDs, and will essentially give you an incrementing row number, beginning at 0. - Finally, create a Single Value column. This should be targeted at the Email column in your User Profiles table, targeting the _n_th row from the start, where _n_ is the Row Index (previous column) Here is an example of how that would look: ![Screen Shot 2022-03-12 at 10.06.44 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/f/1f5bb326968a24054edc87051d2cbbb48458d07c.png) ---
**Author:** ![rahul482](https://avatars.discourse-cdn.com/v4/letter/r/e9c0ed/32.png) [@rahul482](https://community.glideapps.com/u/rahul482)\ **Post date:** [March 12, 2022, 2:35pm UTC](https://community.glideapps.com/t/how-can-i-get-data-from-other-sheet-without-relation-and-lookup-columns/39547/6 "2022-03-12T14:35:43Z")
Wow, thanks @Darren_Murphy it works, is this is the ideal process to auto increment. in the glide. PS. One Concern will it effect tomorrow if we scale, let suppose tomorrow we get 500 users, then that lookup column will be filled with all the row ids, will it effect in speed.? ---
**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\ **Post date:** [March 12, 2022, 4:08pm UTC](https://community.glideapps.com/t/how-can-i-get-data-from-other-sheet-without-relation-and-lookup-columns/39547/7 "2022-03-12T16:08:56Z")
No, that won’t have any negative impact. You just need to ensure you have enough rows in that table. ---
**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\ **Post date:** [March 13, 2022, 4:09pm UTC](https://community.glideapps.com/t/how-can-i-get-data-from-other-sheet-without-relation-and-lookup-columns/39547/8 "2022-03-13T16:09:52Z")
This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.