When sorting, selecting “Empty values last” doesn’t always work. Is there any trick or special conditions for it to work properly?
A likely explanation could be that what seems like an empty value might not be. For example, perhaps you have a cell with text that just has spaces instead of being a completely empty string.
Do you have a public example of where sorting by empty value isn’t working as you expected?
Thank you for your reply. I don’t have a public example. I tried to cut and paste what doesn’t work into a sharable document and the problem disappeared. I suspect it has to do with my use of formula. If I use a formula to write to it when some condition is satisfied but not when it’s not, will it still leave a hidden value in the cell?
What type of value is the formula in the cell returning? Perhaps it’s returning False, but based on the column type it’s just appearing as a blank?
The one I’m struggling with right now uses NOW() as a triggered formula. The column type is Datetime.
I also have widgets where when sorting by date, “empty values last” doesn’t have any effect whether I’m sorting ascending or descending.
Same problem for me. This only works for Strings. Empty values (which I assume should mean None values, or Nulls in SQL) of all the other types always sort to the end.
This issue still exists, is a GH issue needed?
I believe this issue covers it.