This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Hi John, what’s your use case? It sounds like you might be able to do what you want just by creating a separate view on the same table and hide the fields you don’t need for each.
Thanks for your response. I ultimately want to add additional columns to this new tab/ view. If I were to create a new view, would this then require that I hide columns on both views?
Is there a cleaner way to simply pull the 4 relevant columns of data to a new sheet?
If the 2 Tables contain elements of the same type, you should use Views. If they are different but Related, you could use a Linked Record field and then Lookup fields to reference data. For instance, think of Events and Venues tables: you can have an Address field on the Venue, and show it on the Event/s (always the same address for events in the same Venue).
Continuing with your example, lets say I have venue names in the first column. Then I have columns of venue capacity, venue address, ticketing URL, and age restriction. I want to pull the data from two of these columns into another Tab/Table. In Sheets the =IMPORTRANGE function can achieve this.
