Can I filter or sort by highlighted changes?

elijah.montgomery

I have a project tracker sheet that is set up so that we can import a file from our customer regularly that updates existing worksites, and adds new ones to our tracker sheet. We are able to use "Highlight changes" to easily see what cells are updated and what rows are added. What we would like to be able to do, either in a report or in the tracker sheet, is to filter or sort by the changed columns. For example, if I want to filter to only see sites that have had a change to Store Open date, or to only see sites that have had a change to the equipment type requested. Is there a simple way to do this?

The best method I can think of is off hand is to add hidden helper columns to record the date any cell change is made, but that means adding a helper column and automation for every single column, and I'd rather not have to go that far.

Brian_Richardson

You cannot directly filter for that, you'd need to filter for a range of Modified Date system column values, or like you said you could add automations that would capture change dates for specific items and filter for those dates.