Hi team,
It appears that in google sheets the sort order is number first, date and lastly text. Would anyone know how to sort so that text is first, then date in chronological order a-z i.e. most recent first?
In the first example, when the sort order is set to true, date is sorted correctly but text is last. I need the 'ongoing' rows to always show at the top followed by date order 11 May, 29th May, 2 June.
It appears that in google sheets the sort order is number first, date and lastly text. Would anyone know how to sort so that text is first, then date in chronological order a-z i.e. most recent first?
In the first example, when the sort order is set to true, date is sorted correctly but text is last. I need the 'ongoing' rows to always show at the top followed by date order 11 May, 29th May, 2 June.
