Create a Form with Auto Filled
I have a sheet (Sheet 1) that is my Master Project. Each project has to create subtask request for another department (within Sheet2) but a lot of information prefilled in Sheet 1 needs to be fulfilled into Sheet 2 when the request is made to that other department.
Is there a way to create a form within Sheet 2, use the Hyperlink to the form and add in the URL some GET Variables from the request? Like create a custom Hyperlink based on columns values from Sheet1?