Create a Form with Auto Filled

Mathieu Gaboury

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?

Andrée Starå

Hi @Mathieu Gaboury

I hope you're well and safe!

You could maybe use the URL-query feature.

More info:

Use a URL query string to specify different default values for a form | Smartsheet Learning Center

https://help.smartsheet.com/articles/2478871-url-query-string-form-default-values

After you create a form, you can customize the URL outside the Smartsheet app with a query string. 

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Mathieu Gaboury

Ok that's a start using the standard URL Query typo, but let's say i want to use values from the current row to auto-populate based on Formulas like below :

Rep = the Field in the form from Sheet 2

[Store #]@row1 = the Value from Sheet 1 column Store # row # 1. The hyperlink is actually in Sheet 1

https://app.smartsheet.com/b/form/6145a2c33c4e42e68bf53900e4a4845b?Rep=[STORE #]@row1

juliebice

I too wish to be able to do what is mentioned below - utilized an entered value in the form to put in the link that the user is sent to when they submit the form. This will allow for a consistent primary key to be utilized to group all iterations of the form submission.

Mathieu Gaboury

Jan 18, 2022

Ok that's a start using the standard URL Query typo, but let's say i want to use values from the current row to auto-populate based on Formulas like below :

Rep = the Field in the form from Sheet 2

[Store #]@row1 = the Value from Sheet 1 column Store # row # 1. The hyperlink is actually in Sheet 1

https://app.smartsheet.com/b/form/6145a2c33c4e42e68bf53900e4a4845b?Rep=[STORE #]@row1