Can I show the same spreadsheet tab as multiple tabs in my app, but sorted, filtered or displayed differently?

(not sure if it goes here or in Features request)

Posting back here a question I had in Spectrum but I think was missed. I love the filtering option but it seems that you can only apply it to one tab. Is there a way to have other tabs with the same sheet but filtered in different ways?
Or should I do some Google sheets manip to make this work (duplicating the same sheet several times to create the relevant tabs in Glide and then filtering each one individually)?

Hey @Stephanie_Bonnet, good to see you here. :slight_smile:

You can’t do it easily with tabs at the moment, but you can if you link to that screen with a button or image. I’m sure you can probably do the same with references as well.

In the GIF below you can see I’ve sorted my same sheet in two different ways and in the last one I’ve filtered it.

You could use arrayformula to copy data from one sheet into another and then sort that differently. That would be the way to do it with tabs.

Thanks I think i’ll start studying how to do array formulas then as the image option may not work with the cross reference lists that I have now.

We plan to make this much easier soon! You will be able to create many tabs that are all independently configurable views of the same sheet.


Ouh very very exciting!!!

As a workaround, you can write QUERY functions to filter and sort data at the same time.
One QUERY formula every new tab. :slight_smile:

Would that allow for new data entered into the main tab to be automatically updated and filtered appropriately in the other tabs?

Yes. Just have the range properly set in the query.