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.