Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Mar 01, 2019 09:44 PM
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?
Solved! Go to Solution.
Mar 05, 2019 02:43 PM
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.
Mar 05, 2019 10:26 AM
Is this just not possible?
Mar 05, 2019 02:43 PM
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.
Mar 05, 2019 06:39 PM
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:
Mar 06, 2019 10:55 AM
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.
Nov 16, 2021 12:56 PM
Gosh, this just solved one of my smallest but most annoying issues – thank you!
Dec 05, 2023 08:04 AM
Thank you this is great, but it doesn't seem to work for dates. Do you know how that could be set up?