Sorry if this question has already been answered but I am having a hard time clarifying what I am looking for to search.
I have a sheet of employees with a helper column (called structure) that is displays their job title as a number using descendants (lower the number the higher their position). If needed this can be reworked to have the lowest ranking employees have the lower numbers.
I have another sheet that is the master schedule where employees will be assigned tasks. I have columns for completion, who is assigned (multi-person select contact column), how long the task took and a column for comments on why something took longer than expected if required.
Multiple employees will be assigned to a single task each day/week and I want to send an update request only to the highest ranking employee assigned. This way I don't have other employees overwriting each others entries. Also the higher ranking employees have a better idea of everything that goes into a task and can give a more in-depth update. I think its the multi-sheet logic that's making this hard for me.
I have a work around where another column is created and whoever assigns the task will put the highest ranking person in as the contact person manually. But I can already see my team assigning tasks and not using the contact person column.
Is there a way to send an automated update request only to the highest ranking employee assigned based on their role in the employee sheet to the task assigned in the schedule sheet?
