Help

Save the date! Join us on October 16 for our Product Ops launch event. Register here.

Re: Display values before blanks in sort?

Solved
Jump to Solution
1928 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Bob_G
5 - Automation Enthusiast
5 - Automation Enthusiast

If I have 5 blank rows, then values 5, 10, 15, and I sort by that column, those blank rows show at the top and I would like them to show at the bottom but the 5, 10 and 15 still sorted showing at the top. Is this possible?

1 Solution

Accepted Solutions

Not directly. Make a formula field with this formula IF({Whatever field you're currently sorting by},'A','Z'). Sort first by the formula field then by the original sorting field with your 5,10, 15 values.

See Solution in Thread

6 Replies 6
Bob_G
5 - Automation Enthusiast
5 - Automation Enthusiast

Is this just not possible?

Not directly. Make a formula field with this formula IF({Whatever field you're currently sorting by},'A','Z'). Sort first by the formula field then by the original sorting field with your 5,10, 15 values.

Bob_G
5 - Automation Enthusiast
5 - Automation Enthusiast

edit: I misread, you meant add a new column with that. I did that, it works great I will just hide it. Thank you so much! :hugs:

Damn, but that was awfully clever. :thumbs_up:

I hate to think how tortuous any solution I proposed would have been; I know my initial, unsuccessful attempts certainly were.

Gosh, this just solved one of my smallest but most annoying issues – thank you!

jmarcusw
4 - Data Explorer
4 - Data Explorer

Thank you this is great, but it doesn't seem to work for dates. Do you know how that could be set up?