I tipi di file classici non potranno più essere utilizzati a partire da gennaio 2021. È possibile effettuare la transizione dei file classici o scaricare un PDF. Ulteriori informazioni

Is there a way to automatically refresh filtered data in a spreadsheet or document?

Con risposta
Richiedi una demo
I have a table of data in a spreadsheet. I want some records to appear in one section of a document and other records to appear in other sections of the document. I accomplished this by linking the entire data table to each section of the document and applying different filters to each section of the document.

However, when the source data in the spreadsheet changes, the filter results in the destination aren't updated. Is there a way to automatically refresh all the different filters in document to account for changes in the number of records in the source data?
2

Commenti

3 commenti

Data Voti
  • Rachael Abdelkhalek

    Thanks for reaching out. I did some digging and discussed with our Product Team on this. Currently, the data in a filtered range does not automatically update if new values are added (as you are seeing). The good news is they are working on addressing this so that once a filter is established, any new data added will automatically become filtered as well.

    I've made them aware of your instance and will keep you updated on this post with any new developments going forward. In the meantime, let me know if you have any questions for me or need anything else. Thanks again for your question. Looking forward to chatting with you further in the Community. Cheers!

    1
  • Dan Packer

    Every month we have over 60 tables that we manually redo the filters for.  This feature would be incredibly useful to our team too!!   Thanks for the update and we look forward to it coming into effect.

    2
  • Omar Fernandez

    Hello. I am curious is this has been deployed to spreadsheets? thank you. 

     

    0

Accedi per aggiungere un commento.