Filter a column then sort on multiple columns

1

I have searched for help on this, but haven’t been able to find anything that has worked for me.

In the example below in the view table, I am trying to filter on Column 3, but then want to sort on Column 2 first and then sort on Column 1. Any time I have attempted to use a formula to sort on the two columns, it messes up the filter. If anyone can help with this, I would appreciate it. Thanks.

[ ]

2

What do you mean by “messes up the filter”? Works fine for me:
(it’s View of Main Table, added two sorts with existing filter)

image

3

Oh my heck, I knew it had to be something simple. I just knew there had to be an easier way to do it, then what I was trying. I was trying to do it based on the individual columns and using a formula. In all my searches on how to sort multiple columns, not one that I found mentioned or showed that awesome little icon on sorting the table. Everything that I found was showing formulas so that is what I was trying to figure out.

Thanks