google contents of a cell

I use smartsheet to track Fedex shipments and billings to clients. One column has the fedex tracking numbers. Currently if I need to track, I go to the column, copy the tracking number, open a new chrome browser window and paste it in and with one additional click I get tracking data. Is there a way to make every entry in a column add the number to a link and open a browser and track? I would love to add the tracking number to https://www.fedex.com/fedextrack/?trknbr=xxx, Where xxx is the tracking number. So one click on the cell entry will open a new window and track. Can this be done?

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!