Would like the Filter in Dynamic view to have the option for (Current User).
Sign in to see the current vote count, add your own vote, or leave a comment.
Hey @Stonelaw119
Good news! The "Restrict view by current user" feature in Dynamic View does just that. Select the contact column that you want to filter by and the user looking at Dynamic View will only see their rows:
Here's more information: Dynamic View: Create and manage views of your data
Cheers,
Genevieve
I do know about this option but I need the teams to be able to see all items and then have the ability to Filter for their own items when needed. The hope was to create a shared filter with (current user) so everyone wouldn't need to create their own personal Filter.
Thanks for clarifying! Is there a reason why the source sheet or report (showing all rows) won't work in this scenario?
I do not want to grant access to the source sheet so I am using dynamic view for the larger teams to make updates on individual rows. One Dynamic view is using the source sheet and another Dynamic view is using a report for that is filtering rows for OPEN items.
The filter in DynamicView doesn't have the (current user) option to allow a shared filter for all to use. Currently, I would have to create filters for each person to use if they wanted to just see their own rows. Or they would need to create their own filters.
Hi @Stonelaw119
Thank you again for providing more context, this really helps to understand how the request would benefit you in your process. I've moved the idea back into the Product Ideas section so if other members have the same use-case they can vote on this as well!
You're correct, you would either need to create another, separate Dynamic View to show the "current user" version or set up specific filters for each user to help them get to a personalized view.
You should be able to create and share a filter for "Current User" on the source sheet for your Dynamic View. As long as this filter is shared, it should display with the filters available in the DV. Set the Dynamic View to no restrictions and the current user can adjust the filters as needed. You should be able to create other, more targeted filters that use multiple criteria, including "Current User" (think Project Lead = "Current User" AND Status = "Open", to display only open items for the current user listed as Project Lead). Have you tried something like this?
Have you actually seen this work? the new SS plans are destroying our entire process and i'm scrambling to see what we can and cannot work. I have a similar use case as to what's posted above (needing them to see what is available and what is currently assigned) and I don't see any shared filters coming through to the DV and 'current user' is definitely not an option when creating filters in the DV
We need the ability to duplicate (copy) an existing dynamic view to other sheets. We use templates and Smartsheet Control center, but when creating a new sheet (using SCC or Save As New) the dynamic view(s) are not also copied/duplicated. This creates a LOT of manual re-work. It'd be great if, from the Dynamic View…
Good afternoon, Recently there was a change that made searching a dropdown by typing inside of it switch from an exact match method where typing S would only show entries that begin with S to a search within method where typing S would show all results with the letter S in them. I can see how this would be beneficial in…
Please add the highlight changes feature to the new Tables view!
