Classic file types are no longer available for use as of January 2021. You can transition your classic files or download a PDF. Learn More

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

Answered
Request 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

Comments

3 comments

Date Votes
  • 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

Please sign in to leave a comment.