Help

Add a fedex formula link to track a package

2061 3
cancel
Showing results for 
Search instead for 
Did you mean: 
SCOTT_GARDNER
5 - Automation Enthusiast
5 - Automation Enthusiast

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 3
Zollie
10 - Mercury
10 - Mercury

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?

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