Sharing with default Filter applied

Question

I am wanting to share content that has a default filter applied where it only pulls specific rows (leveraging "Current User") filter.

Originally, I had tried leveraging a report, however, that does not allow the user to be able to add rows and self assign (unless experiencing user-error).   Having a report is my preferred method, however, I can't figure out a way to let the user add more rows.

I thought there was a way to share a sheet (publish?) that defaults to a set view (Grid) and a default Filter.   I can't seem to find this setting anymore.

I can see that I'm able to select at the time of sharing, as below.  I guess more importantly now, is how do I do this for users that have already been shared??

@Andrée Starå or @Paul Newcome   Any thoughts?

Ray Lindstrom · Answer

This is always a good idea, and you can put both files on a dashboard for a one-stop-shop.

Kerry St. Thomas · Answer

How about using your report filtered to Current User for existing row maintenance, and then separately create a form to allow users to add new rows?  (One thing to think about if you did this - would you need to capture who filled out the form in order to ensure they'd have visibility on the Current User filter? or would it be more appropriate for the Report to filter to Current User or Blank?)

Ray Lindstrom · Answer