Formula address to google maps


I am having trouble finding this post. I remember seeing a post with a formula that automatically creates a link to google maps with an address pulled from a column.

Address is typed in column by street then Alt enter then city, state, zip.

I have looked high and low for the post but can't find it.

Does anyone know a formula that would work?

I have this but because of how I type the address in it (street and hit alt enter) this formula only only does the street in google maps.

="" + SUBSTITUTE([Job Address]@row, " ", "+")


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!