What is the best way to set up an approval matrix for multiple approvers across multiple departments?
For example, I am working on a sheet for employee travel requests. So the employee will fill out a form with their demographic info and input the cost of the travel broken down (airfare, transportation, hotel, ect). I then want the sheet to trigger to be sent for approval to the corresponding manager depending on which department is input on the form. After the manager approves, it must go to a financial analyst (there are only 3 to choose from), and after the analyst approves, it must go to the executive director (again, only 3 to choose from), to provide final approval.