Permissioning

stephanie.blake67241

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?

 

Mike Wilday

 Yes, they should be able to edit as a collaborator. They will not be able to manipulate the layout or add new columns. 

stephanie.blake67241

But they can add new rows? 

Mike Wilday

Yes! Definitely!

stephanie.blake67241

Thank you!

stephanie.blake67241

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?

Mike Wilday

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.