Field AutoFill Options

Bessie Koch

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("https://www.mpp.org/states/", [State Name]@row, "/")

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

Thank you!

Paul Newcome

You need to "add" the pieces together.

="https://www.mpp.org/states/" + [State Name]@row + "/"

Paul Newcome

You need to "add" the pieces together.

="https://www.mpp.org/states/" + [State Name]@row + "/"

Bessie Koch

PERFECT!! Thank you!!

Paul Newcome

Happy to help. 👍️