google contents of a cell

lux

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?

SteyJ

https://community.smartsheet.com/discussion/114260/google-contents-of-a-cell

It sounds like you already have the tracking link in the sheet, if that is the case you can simply do this:

where fedex link column is:

="https://www.fedex.com/fedextrack/?trknbr=" + [Tracking #]@row

lux

Hi Jacob, Thanks for the input. Your formula works great with an additional column added. And this gives me ideas for other web search functions on other sheets. Yes, I have the tracking number specifically in a column called "airbill number". But is there a way to make the actual airbill number from the tracking column be the link? I am trying to not add extra real estate or columns to the view. Would love to just click on the column entry and get a new browser window with the fedex tracking info.

SteyJ

https://community.smartsheet.com/discussion/comment/409246#Comment_409246

Unfortunately not. The best option would just make a really small column next to the air bill number where you can see the start of the URL, and then click on it that way without taking as much real estate .

lux

Hi Jacob, yes, that is what I have done. It is not a bad solution. But still just wondering if there might be another method. About 12 years ago I set up filemaker ( a desktop Mac database) so I could click on one cell and it would google the contents of that cell. It made using a potential client CRM work really efficient.

marc4

You could use the API to update the sheet every hour or so and if the tracking number is not blank set the hyperlink of the cell to the fedex link with the tracking number

/marc

lux

https://community.smartsheet.com/discussion/comment/425176#Comment_425176

Hi /marc that is a great idea. we just switched from exclusive fedEx to UPS/USPS/FedEx, however I can set this up to just google the tracking numbers. ="https://www.google.com/search?q=" + [Tracking #]@row . Any quick advice on working with the SS API's?