Display values before blanks in sort?

[Bob_G]

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?

[Bob_G]

Is this just not possible?

[Kamille_Parks · Accepted solution]

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]

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:

[W_Vann_Hall]

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.

[Cameron_Dunn]

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

[jmarcusw]

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