Fields Will NOT Add to Form After Completing Formula

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.

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.

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!

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

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):

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

Thanks!