Sign in to join the conversation:
I'm trying to put together a saved filter and I would like to have one of my filters sort alphabetical. Is this possible?
Thanks!
My experience is you have to sort your rows first, then apply your filter.
Filters will not resort the rows when selected. They will only filter the results in the current sorted rows.
Craig
I thought that was the case but even when I sort alphabetically it isn't correct. It basically breaks the sheet up into 2 sections of A-Z.
For instance, it will list my rows A-Z and then start a new A-Z under the 1st set. It won't take all rows and make then A-Z from row 1 to the end.
Thanks Craig,
One other question - when I turn on my filter it will say 71 out of 73 rows filtered. Is there a way to see which rows weren't filtered?
To create a "unfiltered" list, you need to create a second filter.
I often have a "Late" and a "Not Late" set of filters if it comes up enough.
Hi all, I’m looking to get more up to speed with Smartsheet timelines, especially features like Gantt charts, dependencies, milestones, and overall timeline best practices. I’ve already built out one sheet and understand the basics, but I’d love to learn more about the tips, tricks, and best practices that more experienced…
We changed from an enterprise licence to specific accounts. I have a licence and setup a workspace for our global team to edit and collaborate across various sheets. I granted editor can share rights to all non licensed members and shared the publish link with them. This has worked well and allowed them to edit cells,…
Hi! I have a sheet that has two form that feed into it. This is to report on Closures due to Staffing, Weather, and Facilities. One team submits closures for Staffing and Weather, while another team only submits Facilities. When I created this set up I have it so the one team gets asked "Reason?" then they can select…
