There is a saying: Yesterday is history, tomorrow is a mystery, but today is a gift. That is why it is called the present.
Kung Fu Panda
Auto-sorting priority tables based on a separate table of dropdowns in Google Sheets
Huge disclaimer: I’m no Excel/Sheets master so there is probably a much better and more efficient way of doing things but this is just an extremely hacky thing I threw together one afternoon. So if you know of any alternatives, I’d be happy to hear it. Also I am not a teacher but I’ve renamed a few things to try and simplify things. The setup Class Sheet, Table 1 – also known as the “input …