How to Pre-Populate a field in a form with a unique ID?

Hello Community,

I am asking for your help today figuring out a challenge I am currently facing. We are trying to pre-populate the "Work Order ID" field in the form because it is often overlooked or entered incorrectly. We have been trying to figure it out but it is hard because you cannot have a column formula field in the form, so we must figure out a workaround. I tried making an automation to record a unique ID in the field, but we can't use formulas in the automation to calculate the unique ID. We are stuck and out of ideas at this point.

Any help here is greatly appreciated! Let's figure this challenge out.

Thank you



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!