Hello
So, in a project I'm supervising, I built a tasks sheet which contain number of tasks assigned to different collaborators. I was expecting that every collaborator will be able to only update the rows which are assigned to him only as I specified in the Assigned To column. But what I found is that everyone with edit permission can edit everything in the sheet, which can cause a lot of mess!
Therefore, I was thinking! How to allow different collaborators in one tasks sheet to have different update permissions to edit or update only the tasks (or raws) assigned to them via the Assigned To fields?