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.
The Issue My project-specific metadata sheets use INDEX/MATCH formulas that reference the Intake sheet using a Project ID. When the automation archives rows from the Intake sheet, these formulas break because they can no longer locate the source data. Example formula: =INDEX({Project Intake Name}, MATCH([Project ID 1]@row,…
Two of my five automation workflows appear to have just randomly stopped performing on April 9, 2026. All others, which would/are performing as normal and would be functioning alongside the other workflows, are functional and appear to be untouched by this 'bug'. Help I've tried all that I can think of.
I need to add 2 horizontal lines to my stack chart to show when we have over allocated for our resources and where our average is. Does anyone know how to make this happen in a Smartsheet dashboard?
