Google Spreadsheet Integration: I would like to merge all of the sheets capturing the registrations into one sheet as several tabs

  • Profile Image
    sciencemill
    Asked on March 06, 2018 at 11:24 AM

    Hi -

    I want to start by saying thank you to anyone who has helped me with my many (often frantic) questions along the way. Our camp registrations have started rolling in and are landing in the google sheets as needed. I have looked around for the answer on this but am a little stuck. In my perfect world I would like to merge all of the sheets capturing the registrations into one sheet as several tabs. Then I would have a tab all it's own with a countif formula to let me know the total registrations for any given camp as those sheets populate. Anyone have any ideas on this one? 

    Thanks!

    Cindy

  • Profile Image
    BDAVID
    Answered on March 06, 2018 at 12:29 PM

    In this case, you can try the Import Range feature Google Sheets provides, to pull the data from the integrated spreadsheets into another one: https://support.google.com/docs/answer/3093340?hl=en 

  • Profile Image
    sciencemill
    Answered on March 15, 2018 at 10:50 AM

    Thanks so much for the info BDAVID! I was finally able to figure out the countif/importrange formula and it worked once, but when I tried to apply the same formula in another cell using the url for the sheet referenced by that line I got the number 1 rather than the actual count as I saw the first time I used it. I am working on these in a form called camp registration totals in my jotform folder and the cell where it works is E8 and the one where it is showing 1 is E4. ANy other ideas on this are greatly appreciated. Maybe this is more of a question for a Google forum?

    Thanks!


    Cindy

  • Profile Image
    TREVON
    Answered on March 15, 2018 at 12:10 PM

    Unfortunately this seems to be more of a question for Google forums as i may not be in a position to offer comprehensive solution on this issue.

    Kindly use the following forum as they may be very helpful on this.

    https://productforums.google.com/forum/#!topicsearchin/docs/category$3Aspreadsheets%7Csort:relevance%7Cspell:false