I have two forms that contain similar information. One asks for more in-depth information that is needed sometimes from external customers while the internal one doesn’t need as much information.
I have them both feeding to a single sheet with multiple tabs. I’d like to have a third tab that will automatically take all the information from each and put it into the correct columns for the specific form.
So say I have two tabs on a sheet:
|Name 1||Problem 1||Email 1|
|Name 2||Problem 2|
How do I get a third sheet that will update to something similar every time a new form is submitted?