When working collaboratively on the same worksheet, several users might have different filtering needs when looking at the rows. For example:
- user 1 needs to see only those rows with values in column E = ‘Completed’
- user 2 needs to see only those rows with values in column E = ‘To Be Verified’
However, according to how filters currently work:
If user 1 creates a filter to only see those rows with E = ‘Completed’
user 2 won’t be able to see other rows or apply other filter criteria only seen by user 2. If user 2 does so, it will modify the view of user 1.