Skip to main content

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?

Is this just not possible?

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.

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:

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.


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.

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.


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

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

 

Reply


Terms & Conditions