# Migrating from Google Sheets - how to create and sort a unique list in Glide Tables **URL:** \ **Category:** Ask for Help\ **Created:** [June 4, 2024, 10:31pm UTC](https://community.glideapps.com/t/migrating-from-google-sheets-how-to-create-and-sort-a-unique-list-in-glide-tables/73877 "2024-06-04T22:31:34Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![matt45](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt45/32/58759_2.png) [@matt45](https://community.glideapps.com/u/matt45)\ **Post date:** [June 4, 2024, 10:31pm UTC](https://community.glideapps.com/t/migrating-from-google-sheets-how-to-create-and-sort-a-unique-list-in-glide-tables/73877/1 "2024-06-04T22:31:34Z")
I’m wanting to migrate an app from Google Sheets to purely Glide Tables, but I’m not sure how to replicate some features. I have a dashboard that managers are able to click in and view weekly reports submitted by their staff. They see a list of Mondays that represent each week: ![Screenshot 2024-06-04 at 5.13.44 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/f/2fe3df8b98d5c2711e2729a0fb969c52302321eb.png) In Google Sheets I have Sheet #1 that is a log of submitted weekly reports and then in Sheet #2 I use `=sort(unique('Weekly Reflections'!E2:E),1,false)` to find each unique Monday and then sort them in descending order. I then use that column to create Relations & Lookups, generate some stats, etc. It’s rather simple and straightforward in Google Sheets but I haven’t the slightest clue now to reproduce this purely via Glide Tables. Any advice would be much appreciated! ---
**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:** [June 5, 2024, 12:15am UTC](https://community.glideapps.com/t/migrating-from-google-sheets-how-to-create-and-sort-a-unique-list-in-glide-tables/73877/2 "2024-06-05T00:15:39Z")
What would happen if nobody submits in a week? Would it show up as a row with 0 Submissions, or doesn’t show up at all? I would expect it to show up, and in that case, I would have a helper table where you: - Add as many rows in advance as you need, say 100 rows for example. - Add a rowID column. - Use a lookup column, targeting the full rowID column that you have just added. - Use a “Find Element Index” column, pointing to the array of rowIDs, and find the rowID of the current row. This would give you an index column starting from 0 and ending at 99. - In another table, I would usually use a Choices table for this, add a “Date Start” column and add the first Monday in your database to the first row of that column. - Back to the helper table, use a single value column, target the Choices table, bring over the first value from that “Date Start” column. - Add a math column: DS + I\*7 with DS being the Date Start, I being the index. You would have a list of dates on Monday, ranging from index 0 to 99 with each one 7 days after the previous. ---
**Author:** ![matt45](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt45/32/58759_2.png) [@matt45](https://community.glideapps.com/u/matt45)\ **Post date:** [June 5, 2024, 12:42am UTC](https://community.glideapps.com/t/migrating-from-google-sheets-how-to-create-and-sort-a-unique-list-in-glide-tables/73877/3 "2024-06-05T00:42:31Z")
> [@ThinhDinh](#): > > What would happen if nobody submits in a week? Would it show up as a row with 0 Submissions, or doesn’t show up at all? Via my method in Google Sheets if nobody submits in a week it wouldn’t show up at all, because the formula only finds the unique dates amongst the submissions, so naturally what isn’t submitted won’t be found. ---
**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:** [June 5, 2024, 12:44am UTC](https://community.glideapps.com/t/migrating-from-google-sheets-how-to-create-and-sort-a-unique-list-in-glide-tables/73877/4 "2024-06-05T00:44:59Z")
You still can use my method and hide the weeks where there are no submissions. ---
**Author:** ![matt45](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt45/32/58759_2.png) [@matt45](https://community.glideapps.com/u/matt45)\ **Post date:** [June 7, 2024, 7:49pm UTC](https://community.glideapps.com/t/migrating-from-google-sheets-how-to-create-and-sort-a-unique-list-in-glide-tables/73877/5 "2024-06-07T19:49:09Z")
Thanks for your help, ThinhDinh! I appreciate you taking the time and promptly supplying a solution! ---
**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:** [June 7, 2024, 11:16pm UTC](https://community.glideapps.com/t/migrating-from-google-sheets-how-to-create-and-sort-a-unique-list-in-glide-tables/73877/6 "2024-06-07T23:16:13Z")
My honor to help! ---
**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:** [June 14, 2024, 11:16pm UTC](https://community.glideapps.com/t/migrating-from-google-sheets-how-to-create-and-sort-a-unique-list-in-glide-tables/73877/7 "2024-06-14T23:16:42Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.