Add a fedex formula link to track a package

[SCOTT_GARDNER]

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

[Zollie]

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.

[SCOTT_GARDNER]

Appreciate that!

Am I missing something, the formula looks the same?

[Zollie]

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