I'm rolling out a new process with a client and constantly finding areas where I need to use a work around, only to find that solution won't work in another aspect.
For example, I have one sheet with sales data that needs to be updated constantly by the sales team, however, I don't want them to have access to the sheet, even at a viewer level. So, we decided to use Dynamic View, however some of the basic functionality of sheets doesn't work in DV. (i.e. using the @mention for sending comments, freezing columns, etc.).
There are also a number of reports that they will need to utilize, however I either have to set these up for visibility in Dynamic View - where I can't utilize any of the new grouping or summarizing functionality or create a separate published report for each individual person on the sales team, since the "Current User" functionality doesn't work in published reports.
Has anyone experienced the same limitations? Are there workarounds I'm not thinking of? Even just being able to publish a report with a current user filter would solve so many of the issues I've created workarounds for. What would be really great would be creating reporting that can be shared (just as view only) w/out having to share the underlying sheet.
Any recommendations would be appreciated!