Permissioning
If I want to share a sheet with someone outside my company and give them the ability to update columns I've created (i.e. % complete) as well as add new rows, can they do this under the "free collaborator" permissioning? If not, are there any workarounds?
Comments
-
Yes, they should be able to edit as a collaborator. They will not be able to manipulate the layout or add new columns.
-
But they can add new rows?
-
Yes! Definitely!
-
Thank you!
-
One more question - can I limit what that person can see in the file? What if I only want them to be able to see rows that they are the owner of?
-
That's a little trickier. Unless you purchase the add-on feature called Dynamic View. If a user is shared on a sheet as an editor they are able to see all of the rows. You could create a report for the user but they would still have to have access to the entire sheet. You could consider creating a separate sheet for each user, and then build a report to pull all the data together. Just some ideas.