Would like the Filter in Dynamic view to have the option for (Current User).
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
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.
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?
Hi Community, Welcome to the Product Feedback and Ideas space where you can help shape the future of Smartsheet! We really appreciate your feedback and will take all posts into consideration. Our product team will review top ideas and requests monthly and we'll share updates as soon as we get them. Remember: if you have a…
It would be very useful to see who the sheet has been shared to and when. Also it would be good to see when the sheet has been emailed to a Smartsheet user and when.
Our company recently created a cybersecurity threat assessment as a required template for our PMO to ensure that all projects have the proper security and oversight. After working with stakeholders to fill out the sheet, PMs are marking a checkbox on the sheet that ultimately triggers the Document Generator automation to…
It would be handy to have a mechanism for creating a new sheet from the results of a report. I envision an option in the report menu "Save Results as New Sheet" where you would be prompted to give the new sheet a name and then the report's columns and their contents (as static values) would fill out the new sheet. This…
©2024. All Rights Reserved Smartsheet Inc.