Fields Will NOT Add to Form After Completing Formula

John- Michael Diedrich

I recently had a Pro Help desk call to figure out how to add a pre-populated field to a form. We got it working easily and I will paste the formula below (we added the Work Order ID field to the form because it tends to be filled out incorrectly).

=FormLink?Work%20Order%20ID=" + [Work Order ID]@row

I tried to write this same formula on another sheet to add the field, but it is not working. I did not change a single thing and it is not pre-populating the Work Order ID field like it did before.

Any help here is greatly appreciated, please help me figure out this head scratcher!!

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/348575#Comment_348575

Thank you Leibel!! This worked!

Paul Newcome

Are you able to provide some screenshots?

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/348457#Comment_348457

Definitely, thanks for reaching out Paul.

Here is the formula that works:

Here is the formula that is not working:

The Work Order ID column is named the same throughout our workspace because it is created from a template. I am getting really thrown off by this, but am hoping it's a simple fix.

Andrée Starå

Hi @John- Michael Diedrich

I hope you're well and safe!

You'll have to update the Form Link to the one on the new sheet.

Make sense?

Did 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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/348470#Comment_348470

Thank you for your feedback!

The form sits in the same sheet so the link never changes for it. Whenever a new sheet is created it is automatically output onto it, and we are trying to set the formula up for it to pre-populate the Work Order ID field. Here is another screenshot of what I currently have that does not work.

Paul Newcome

The form URL should be different between sheets. Are you trying to have all forms populate the same sheet?

Andrée Starå

@John- Michael Diedrich

Not sure I follow! Can you elaborate?

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/348493#Comment_348493

Correct Paul, we have the same sheet with the form on it so we will use the same URL.

Hope this helps, if you have any other questions let me know!

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/348510#Comment_348510

Definitely, Andree! We have a sheet where the form sits, so we will use the same form link throughout this. We are trying to have the link prepopulated onto new sheets and include that sheets Work Order ID field in the form, because that is how we differentiate the submissions.

I have used the same formula that worked on another sheet (screenshots are in the comments above) but have had no luck. I have tried going about it different ways but it all ends up not prepopulating the Work Order ID field in the form.

Hope this helps, let me know if you have any questions!

Paul Newcome

I'm a little confused... You are saying here that it is the same sheet, but then you mentioned above that you are creating new sheets. Can you outline the process all in a single post? I think I may be getting something mixed up.

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/348557#Comment_348557

Sorry about that Paul. I actually just explained it to Andree above, please let me know if that helps or if I need to explain more.

To elaborate on what you said though, the form will be in the same sheet (sheet is designated for the form) and we are trying to have the formula setup on new sheets to include the form link and Work Order ID field prepopulated.

Thank you

Paul Newcome

I am assuming the [Work Order ID] column in the new sheet is already filled in? Are you able to provide screenshots of the sheets for reference?

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/348563#Comment_348563

Good question, but it is not filled in. We are trying to prepopulate it with the formula in the new sheets, because people that submit it tend to enter it incorrectly.

Here is the current formula that I am using that does not work (but to me it is written correctly):

Leibel S

@John- Michael Diedrich

What is the format of your work order ID?

John- Michael Diedrich

https://community.smartsheet.com/discussion/comment/348571#Comment_348571

It is a column in our sheets, and it is "Work Order ID". Screenshot of it is below:

Thanks!

Leibel S

Because of the Hash sign in your work ID it is not coming in to the URL...

Change your formula at he end to the below:

+ SUBSTITUTE([Work Order ID]@row, "#", "%23")