# Review my google sheet **URL:** \ **Category:** Ask for Help\ **Created:** [November 19, 2019, 1:00am UTC](https://community.glideapps.com/t/review-my-google-sheet/2127 "2019-11-19T01:00:55Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Francois1](https://avatars.discourse-cdn.com/v4/letter/f/c67d28/32.png) [@Francois1](https://community.glideapps.com/u/Francois1)\ **Post date:** [November 19, 2019, 1:00am UTC](https://community.glideapps.com/t/review-my-google-sheet/2127/1 "2019-11-19T01:00:55Z")
Hey! Can someone review my google sheet and see how I can optimize (remove tabs) it? Here is my Google Sheet : [https://docs.google.com/spreadsheets/d/140Km7Wh0XV4T-X9l9U0G4Yyhe2sE6MZckCwL0ZQIgEk/edit?usp=sharing](https://docs.google.com/spreadsheets/d/140Km7Wh0XV4T-X9l9U0G4Yyhe2sE6MZckCwL0ZQIgEk/edit?usp=sharing) Here is my app: [https://animalt.glideapp.io/](https://animalt.glideapp.io/) I have enabled the possibility to copy the app for tonight so you can analyze the back-end in Glide. Thanks for your time! ---
**Author:** ![Paul](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paul/32/1345_2.png) [@Paul](https://community.glideapps.com/u/Paul)\ **Post date:** [November 19, 2019, 2:28am UTC](https://community.glideapps.com/t/review-my-google-sheet/2127/2 "2019-11-19T02:28:54Z")
Are you planning on allowing users to enter data directly onto the spreadsheet also? If not, you don’t really need to worry about cleaning it up too much - it’s your own design playing out. 😉 If so, then create a single ‘entry’ sheet that is styled to 1) help users quickly fill it in and 2) distribute inputs across your other sheets as it’s filled in. Then you can simply protect and hide all the other sheets so users only ever see the single sheet they need to deal with. That the type of advice you’re looking for? ---
**Author:** ![Francois1](https://avatars.discourse-cdn.com/v4/letter/f/c67d28/32.png) [@Francois1](https://community.glideapps.com/u/Francois1)\ **Post date:** [November 19, 2019, 2:35am UTC](https://community.glideapps.com/t/review-my-google-sheet/2127/3 "2019-11-19T02:35:19Z")
Yes I want animal shelters owners to enter data directly onto the spreadsheet! For what you’ve said, yes it’s true. It’s not important how I set the tabs and all. > [@Paul](#): > > distribute inputs across your other sheets as it’s filled in. How? What’s the formula? Thanks ---
**Author:** ![muazz1m](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/muazz1m/32/189_2.png) [@muazz1m](https://community.glideapps.com/u/muazz1m)\ **Post date:** [November 19, 2019, 3:03am UTC](https://community.glideapps.com/t/review-my-google-sheet/2127/4 "2019-11-19T03:03:35Z")
You can use single tab in sheet. and Use Relation column to remove redundancies of the data. With relation you can set more than one categories for each animal too. ---
**Author:** ![Francois1](https://avatars.discourse-cdn.com/v4/letter/f/c67d28/32.png) [@Francois1](https://community.glideapps.com/u/Francois1)\ **Post date:** [November 19, 2019, 3:06am UTC](https://community.glideapps.com/t/review-my-google-sheet/2127/5 "2019-11-19T03:06:48Z")
Yes I’m using relations between shelters and animals. But for the home and search screen, I didn’t know how to display like this without creating multiple tabs. At the beggining, I had one tab for all shelters and I created columns for ‘categorie 1’ ‘categorie 2’ ‘categorie 3’, etc. (because some shelters have 3 categories). But, it was not possible to display all categories like what we see right now. ---
**Author:** ![Paul](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paul/32/1345_2.png) [@Paul](https://community.glideapps.com/u/Paul)\ **Post date:** [November 19, 2019, 3:30am UTC](https://community.glideapps.com/t/review-my-google-sheet/2127/6 "2019-11-19T03:30:44Z")
Here ya go: [https://support.google.com/docs/answer/75943?co=GENIE.Platform%3DDesktop&hl=en](https://support.google.com/docs/answer/75943?co=GENIE.Platform%3DDesktop&hl=en) EDIT: So you want to style up al the fields to be more user friendly and on those other sheets have them reflect these new inputs explicitly. ---
**Author:** ![Paul](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paul/32/1345_2.png) [@Paul](https://community.glideapps.com/u/Paul)\ **Post date:** [November 19, 2019, 4:38am UTC](https://community.glideapps.com/t/review-my-google-sheet/2127/7 "2019-11-19T04:38:57Z")
I also made a quick sheet demonstrating a simple table… you can also get a little tricker and import data from other sheets using IMPORTRANGE (as demonstrated in Sheet3). > **[Sheet References](https://docs.google.com/spreadsheets/d/19UXYfnkCNU_NkQ4pv42vqQhsR0L00q_ZiVHHXA3_4C4/edit?usp=sharing)** > > Sheet1 > > Name,Age,Email,Phone > Paul,38,paul@fakeemail.co,123 123 123 > Sally,23,sally@test.com,234 234 234 > Fred,76,fred@nothing.io,456 456 456