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.
I have a monthly report I send out that has a long list of recipients. I know I can edit the recurrence of it being sent, but does anyone know of an easy way to just add or take out people that get my email without having to recreate the whole thing?
We would like to allow conference attendees to check themselves in using tablets at the conference center. I know there is a "find in sheet" magnifying glass in table view, but it is not super obvious, especially for non-Smartsheet users. Is there a better way for them to easily find their row among all the attendees so…
Greetings- I have a automation setup when I select the "status" column drop-down to "completed" I want the row info to be emailed to the contact to submitted it with a follow up then I want it to archive the row (aka move to another sheet). When I run the automation only 1 of the 2 requests happen. The archive happens…
