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?
Help Article Resources
Check out the Formula Handbook template!