Field AutoFill Options

I would like to have the beginning of a URL (free type not currently in a column) appear then add the contents from another cell automatically for a list of states.

Right now, I have hidden columns that I am using to concatenate. I have also tried the JOIN function. Is there a more efficient way of doing this? =JOIN("", [State Name]@row, "/")

The Limitations/Laws column shows the final link needed correctly.

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!