Skip to main content

Add a fedex formula link to track a package


Hello-

Does anyone know how to add a Fedex formula to be able to click on a Hyperlink to auto track?

The below is giving me an error.

IF({TRACKING},IF(LEN({TRACKING})= 12,“https://www.fedex.com/apps/fedextrack/”)&{TRACKING})

Thanks,
SG

3 replies

Forum|alt.badge.img+18
  • Inspiring
  • 254 replies
  • January 13, 2020

For sake of readability, I’m adding line numbers and indentations to your code. It won’t run like this - I’m just doing it for demonstration purposes.

1 IF(
2	{TRACKING},
3	IF(
4		LEN({TRACKING})= 12,
5		“https://www.fedex.com/apps/fedextrack/”
6	)&{TRACKING}
7 )

Without knowing what the error message is, my best guess is that your error is occurring on line 6. I believe &{Tracking} should be inside of the parenthesis.


  • Author
  • Participating Frequently
  • 6 replies
  • January 13, 2020
Zollie wrote:

For sake of readability, I’m adding line numbers and indentations to your code. It won’t run like this - I’m just doing it for demonstration purposes.

1 IF(
2	{TRACKING},
3	IF(
4		LEN({TRACKING})= 12,
5		“https://www.fedex.com/apps/fedextrack/”
6	)&{TRACKING}
7 )

Without knowing what the error message is, my best guess is that your error is occurring on line 6. I believe &{Tracking} should be inside of the parenthesis.


Appreciate that!

Am I missing something, the formula looks the same?


Forum|alt.badge.img+18
  • Inspiring
  • 254 replies
  • January 13, 2020
SCOTT_GARDNER wrote:

Appreciate that!

Am I missing something, the formula looks the same?


Yeah it’s the same. Just explaining - not writing the code for you.


Reply