I am looking for a formula where I can use an API to look at a shipper company in another column and link the tracking number to that shipper company. This way the tracking number is a clickable link that takes you directly to the web page for tracking.

another step even further is you look at the link website with API and report back the status of the shipment (picked up, in transit, or delivered) this would make using Click-UP as a one stop shop instead of doing everything manually.