Right…problem is, as I’m guessing, is that the Menu Items are submitted via form entry and thus the app owner has no control over the sheet order. Having an if-then-else to assign a 1-5 number will solve this.
I do this with Dates, too. Sometimes I want to sort user-submitted posts by date, but I also want “pinned/featured” posts on the top. So, I create an if-then-else column called “Sort”. If I’m sorting by date with oldest on top, I do an “if Featured then -1 else date” if I want descending with newest on top then I do “if Featured then 99999 else date”.
Then I sort by “Sort”. Here’s the result: