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
Display values before blanks in sort?
+1Best answer by Kamille_Parks11
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.
+27Is 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.
+1edit: 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?
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.