Are you able to hide specific rows from people on a shared sheet?
I am working on building a sheet for our CEO to track employees tasks and deliverables. However, he wants 1 sheet with multiple viewers (the team) and to be able to make the sheet so that each team member can only see the tasks (rows) they are assigned to and not be able to see any rows that are assigned to other team members or that are blanks. AKA other than the Admin/CEO, team members should not be able to view blank rows/tasks and rows/tasks assigned to other other team members.
Is this possible?