Multiple forms on the same sheet?
I'm working on a Sheet that needs to be completed by 4 separate departments in sequence.
The way I've designed it so far is that department 1 completes a form.
Using the update form function and some automation, I've then linked all the the answers completed by the 1st department with department 2 completing the hidden columns and so on for department 3+4.
Is there another way of doing this? It was a right pain linking all the previous answers completed.
I was thinking some automation to request a new form be completed? Form 1 completed by Department 1, Form 2 completed by Department 2. However Department 2 need to see the answers from Department 1 before they can complete their form.
I'm not sure how I would get the information from form 1 to department 2.