Create a Form with Auto Filled

01/18/22
Answered - Pending Review

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?

Answers

Sign In or Register to comment.