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.