Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Filtering
What's the best way to show just the rows in a sheet that are assigned to me? If I apply a filter to the column it affects the sheet for everyone else, right?
Comments
-
A filter is the best route to go and it won't affect the view for any other shared user.Â
-
I would create a report which you can always go to -- showing just your rows and those columns which pertain to the data you want to see.
-
Either of these methods is good, but I assume that you are using a Project sheet as the category id Project management. Â The report method will not display the Gantt chart element.
Dont forget that data in reports is also editable, they work more like an editable view than being a static report.
-
Can we add a way to add a search bar to the filter dialogue? It would help in quickly adding/removing the filter terms
-
Jeff K - I will add your vote for this!
Â
In the meantime, you can "choose from a list of values" which are organized alphabetically.Â
-
As a side note, IÂ do see that the boxes that are checked (to allow us to apply the filter) are showing - it is just the filter has not been run in "my" view.
-
Just checking for clarification, as I think the answer is above.
Â
We have multiple project managers sharing their budget tracking sheets with a core list of people. We have set up a column to hide rows (using a check box and the filtering option); the PM has turned on the filters to hide the unnecessary rows, but when I go into the sheets, I can see all the rows (i.e., no filtering is applied). Is it correct that the filtering will not follow to shared users - it only appears on viewing the sheet by the person who applied it?
Â
If this is correct, is it something that can be added to the list of requests? If someone has applied a filter, it would be nice if the filter followed the sheet (and any additional viewers/editors could see the same view as the owner).
Â
Thanks!
-
Pam,
Â
Filters are Personal, if two people are viwing the sheet at the same time and one person filters thier view the other person will not see the result of that filter as they have thier own connection to the data and it is showing them the data how they want it.
Â
Reports(Views) are structured and stored filters, but not only of rows but also columns. Â Identify the "Filters" your uses need and create a Report(View) that displays that. Â Some times two diferent views is better than one.
One with cost
One without
Â
One open tasks
One closed tasks
Â
James
Â
Â
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives