@bearon Large(r) sheets require filters.
Users collaborating on large(r) sheets hence require individual filtering.
We are currently experiencing the issue that users changing an applied filter, disrupt and hence prevent other users from entering data in the same sheet (leading to much frustration), due to the common dataview being changed in accordance with the applied filter by one user.
This is unworkable, and hence a showstopper for collaborative sheet editing.
Note : individual filtering is supported by the other major online office suites :
MS Excel (“Sheet Views”) : Sheet Views in Excel
Google Sheets (“Filter View”) : https://support.google.com/a/users/answer/9308952?hl=en
(new user, max. 2 links ; continued in next post)