Search code examples
google-sheets

How to sort items in Google Sheet with custom criteria

I am having items in my Google Sheet under a priority column.

Priority

Must have
Could have
Must have
Should have
Should have

I want to apply the sorting so that all "must have" values are on top then "should have" and then "could have".

Solution 
  • =ArrayFormula(sort(A1:A5,match(A1:A5,{"Must have","Should have","Could have"},0),TRUE))

    Infoinspired