Forum Discussion
Row-Level Security: Different rows for different users
Hello, This is my first post. I am trying to arrange a worksheet in excel for my team. I would like to use it to assign jobs (populate the left columns) and have the team members give status update...
To be more specific:
Rather than manually selecting the range that a user can edit, I would like the user to be able to edit a pre-determined range if the job is assigned to them. In other words, if I have an "Engineer" column where I assign the job to a member of the team, and I put Tom in row 5 of the "Engineer" column, I would like only Tom to be able to fill in the cells to the right of the "engineer" column in row 5. Is this possible?