Display values before blanks in sort?

#1

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?

0 Likes

#2

Is this just not possible?

0 Likes

#3

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.

3 Likes

#4

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:

0 Likes

#5

Damn, but that was awfully clever. :+1:

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

0 Likes