# Spinner to choose spreadsheet **URL:** \ **Category:** Feature Requests\ **Created:** [October 4, 2019, 4:11pm UTC](https://community.glideapps.com/t/spinner-to-choose-spreadsheet/885 "2019-10-04T16:11:33Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![rafafrs](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rafafrs/32/704_2.png) [@rafafrs](https://community.glideapps.com/u/rafafrs)\ **Post date:** [October 4, 2019, 4:11pm UTC](https://community.glideapps.com/t/spinner-to-choose-spreadsheet/885/1 "2019-10-04T16:11:33Z")
I have many monthly spreadsheets, each one with 2 tabs. The idea about the app is that the user can have access to any of those spreadsheets based on month/year he chooses. So, i was thinking about having a month and a year spinners and depending on the selecting, the app shows data from the specific spreadsheet for that month/year. Is it possible to do? Any help on that? ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 4, 2019, 7:40pm UTC](https://community.glideapps.com/t/spinner-to-choose-spreadsheet/885/2 "2019-10-04T19:40:38Z")
Not possible. You can only link your app to one spreadsheet. So multiples are not an option. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 4, 2019, 10:22pm UTC](https://community.glideapps.com/t/spinner-to-choose-spreadsheet/885/3 "2019-10-04T22:22:18Z")
Technically, this is sort of possible, but if you have multiple users, then when one user changes the date, it changes it for everybody. You can do this by using IMPORTRANGE ([https://support.google.com/docs/answer/3093340?hl=en](https://support.google.com/docs/answer/3093340?hl=en)). Like @George_B said, you can’t point your app to multiple sheets, but if you had a list in your main app sheet of all the monthly sheets, then you could use formulas to build the importrange formula based of date and lookups. Again, this would change for everybody when one person changes the date. Personally, I would try to get all of your date into one sheet. Then build another sheet (that will be the primary tab) in the app, with just Month/Year combinations. Then create a reference that links the two together. Rather than a spinner, the user can just scroll through the list to the Month/Year they want and then open it up into all of the data for that Month/Year. ---
**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\ **Post date:** [October 5, 2019, 12:29am UTC](https://community.glideapps.com/t/spinner-to-choose-spreadsheet/885/4 "2019-10-05T00:29:00Z")
Just a warning that IMPORTRANGE will not trigger unless the spreadsheet is open in an interactive browser view. Counting on it is not a viable option in my opinion. Take at look at this old post from the prior community in which I made that mistake myself. > **[I missed the caution about using IMPORTRANGE · Glide](https://spectrum.chat/glideapps/general/i-missed-the-caution-about-using-importrange~f26a978f-c29c-4bc5-8a47-89520b8c1e9d)** > > I'm writing an app that others are going to be required to be changing content. In order to prevent them from screwing up the main application spreadsheet I… ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [October 5, 2019, 12:30am UTC](https://community.glideapps.com/t/spinner-to-choose-spreadsheet/885/5 "2019-10-05T00:30:31Z")
Good to know. Thanks! ---
**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\ **Post date:** [February 10, 2021, 9:29pm UTC](https://community.glideapps.com/t/spinner-to-choose-spreadsheet/885/6 "2021-02-10T21:29:50Z")
Topic appears dormant, archived. ---
**Author:** ![Cisco\_Muratalla](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/cisco_muratalla/32/12358_2.png) [@Cisco\_Muratalla](https://community.glideapps.com/u/Cisco_Muratalla)\ **Post date:** [February 10, 2021, 9:29pm UTC](https://community.glideapps.com/t/spinner-to-choose-spreadsheet/885/7 "2021-02-10T21:29:52Z")