I was wondering if there is an option to export or transfer sheet from one stream to another.
My scenario is as follows, I have:
Stream1 - accessible by User1
Stream2 - accessible by User2
Stream3 - accessible by User3
Now, User1 creates a sheet and he wants to share it to User2 on a Stream2. The idea is not to give to User2 access to login to Stream1 but to keep him in his stream but just to transfer or duplicate that sheet to his stream.
The only way I can think of is if I can duplicate the app in which the sheet is and then publish it in Stream2, but I was wondering if there is an easier way to do it?