Yesterday (4/26/2022), I also had to find out that Google Sheets apparently provides no straight forward and convenient way to filter cells whether they have a comment or not.
This should be part of the standard filter criteria, but it is obviously missing!
This is pretty bad and not easily explainable why such an important functionality is missing. For example, if you have a sheet with over 100,000 cells, most of them filled with data, and you want to know where your data validation rules failed (usually indicated by a comment), then what?
No comments:
Post a Comment