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.
Hello, I'm working through the writing formulas optional activity and in the 'Nested IF function - Progress Column' task it directs you to put in the following formula '=IF([% Complete]@row = 0, “Empty”)'. However, when I put this formula into the spreadsheet, '04a_Marketing Request Tracker - Formulas', I get an…
Have any of you created a Smartsheet that would show the savings for a project by the month? In other words, if I saved $1200 annually and the project ended in say March, then the savings would go $120 per month, Mar 2025-Feb 2026. I have done it on Excel sheets manually, but I think there should be a way to do it with…
I have had approval workflows and notifications built into a couple sheets for about a year now. In the past month, I am getting a lot of feedback saying people did not receive the email request for approval or notification email. It isn't all the time, just sometimes and there does not seem to be a pattern on which ones…
