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
Our program has upwards of 50 active projects at a single time. To assist with team resourcing, we would like to view all our projects in a single Gantt chart where each project and all its phases are condensed into one row, and project phases are horizontally stacked on the same line (swimlane), rather than children in…
It would be extremely helpful if there was a way to have data pull into a form from another Smartsheet source based on selections made within the form. Example: On the form there is a dropdown to select a client property number. The property Name, Address, and any additional property information are then pulled into the…
There is currently a Hubspot integration readily available to connect data into Smartsheet.com We have received an increased need to be able to also connect Hubspot data into smartsheet.eu Is this on the roadmap? If not this would be a great enhancements for many customers.
