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.
