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("https://www.mpp.org/states/", [State Name]@row, "/")
The Limitations/Laws column shows the final link needed correctly.
Help Article Resources
Check out the Formula Handbook template!