Archive form responses so they do not appear in Excel export
I have a long-lived form and I need to archive, hide, or indicate responses that I have 'processed' when they are downloaded to Excel so I only have the responses that have not been actioned or processed.
Amanda McKellar commented
This is a problem for me as well. One of the ways we are currently using forms is as a way to nominate colleagues to be highlighted on our SharePoint site (staff profile). Even though I've cleared the responses from a previous download, all of those responses still appear the Excel document. While I'm able to sort by date and only send information based on previously unprocessed submissions, others on my team who may have to take this on if I'm away won't have that existing knowledge.