My Sheet with all information about all projects generates report.
I have multiple users with different access rights as Survey users in order to only see and manage their own projects in that sheet. And everything works perfect.
But for some reason then user wants to generate report from this sheet Ragic says: You do not have access right to this sheet.
How do I need to set up access rights in order to make it possible for each user to make reports from his own data?