I have the following:
=sort(filter('CASES LIST'!C:R,('CASES LIST'!Q:Q="admission")+('CASES LIST'!Q:Q="pending")+('CASES LIST'!Q:Q="PCI")),16,true)
but I want to sort in the following sequence:
Pending
first
admission
second
PCI
third
Web Applications Stack Exchange is a question and answer site for power users of web applications. It only takes a minute to sign up.
Sign up to join this communityPlease use the following query formula (adjusting ranges to your needs), instead of the filter one you already use.
=QUERY(sort(P1:R,match(Q1:Q,{"Pending","admission","PCI"},0),TRUE),
"where Col2 matches 'admission|PCI|pending' ",0)
Functions used: