Formulas // How to set up one sheet writing to another
I created a project request form for one of my team members -- others on the team enter a request by filling out the form, and so the sheet becomes his workload queue.
Another team member has a schedule on a separate sheet with some items assigned to the same resource. She asked if there is a way that if she selects his name as assigned to a task on her sheet, could some of the data from that row on her sheet be added to the workload queue sheet.
Anyone know how this could be set up?