Is there any way to have Zapier move an entire Sheet's contents?
I am trying to automatically move selected contents of a row that contains confidential information to another sheet that can be viewed by a user who I don't want to access that confidential information. But I also want them to be able to comment on the information if necessary. Otherwise I would just use the report function - however reports require someone to be shared to the full sheet in order to be able to comment on the slice I give them....