Hyperlinks happening regardless of formula

[eli_m]

Hi,

I have this code that has hyperlinking the whole cell regardless of what the formula is.

=IF(OR(ISBLANK([@[Surgery Date]]),NOT(ISNUMBER([@[Surgery Date]]))),"",

IF(OR(ISBLANK([@Material]),[@Material]="TBC"),"Select Material",

IF([@Indication]="Dental","N/A",

IF([@Manufacturer]="Australia","N/A",

IF(ISFORMULA([@[Report & Presc. in PT Folder]]),
IF(AND([@Material]="Titanium",[@Manufacturer]="Germany"),WORKDAY([@[Surgery Date]],-12,Holidays!A$4:$A$103),
IF(AND([@Material]="Plastic",[@Manufacturer]="Germany"),WORKDAY([@[Shipping]],-2,Holidays!A$4:$A$103),
IF(AND([@Material]="Steel",[@Manufacturer]="Germany"),WORKDAY([@[Surgery Date]],-12,Holidays!A$4:$A$103),
IF(AND([@Material]="Wood",[@Manufacturer]="Germany"),WORKDAY([@[Surgery Date]],-16,Holidays!A$4:$A$103))))),

IF(COUNTIF('Pre-Quote Approval Account'!$A$1:$A$10,[@Hospital])>0,
IF(AND([@Material]="Titanium",[@Manufacturer]="Germany"),CONCATENATE("Quote Approval Due: ",TEXT(WORKDAY([@[Surgery Date]],-12,Holidays!A$4:$A$103),"dd-MMM")),
IF(AND([@Material]="Plastic",[@Manufacturer]="Germany"),CONCATENATE("Quote Approval Due: ",TEXT(WORKDAY([@[Shipping]],-2,Holidays!A$4:$A$103),"dd-MMM")),
IF(AND([@Material]="Steel",[@Manufacturer]="Germany"),CONCATENATE("Quote Approval Due: ",TEXT(WORKDAY([@[Surgery Date]],-12,Holidays!A$4:$A$103),"dd-MMM")),
IF(AND([@Material]="Wood",[@Manufacturer]="Germany"),CONCATENATE("Quote Approval Due: ",TEXT(WORKDAY([@[Surgery Date]],-16,Holidays!A$4:$A$103),"dd-MMM")),"")))),

IF(AND(ISNUMBER([@[Report & Presc. in PT Folder]]),ISNUMBER([@[Report & Prescription Sent]])),
IF(AND([@Material]="Titanium",[@Manufacturer]="Germany"),HYPERLINK(CONCATENATE("https://website.com/ui/cases/",[@[Eng '#]],"/case-design"),CONCATENATE("Upload by: ",TEXT(WORKDAY([@[Surgery Date]],-12,Holidays!A$4:$A$103),"dd-MMM"))),
IF(AND([@Material]="Plastic",[@Manufacturer]="Germany"),HYPERLINK(CONCATENATE("https://website.com/ui/cases/",[@[Eng '#]],"/case-design"),CONCATENATE("Upload by: ",TEXT(WORKDAY([@[Shipping]],-2,Holidays!A$4:$A$103),"dd-MMM"))),
IF(AND([@Material]="Steel",[@Manufacturer]="Germany"),HYPERLINK(CONCATENATE("https://website.com/ui/cases/",[@[Eng '#]],"/case-design"),CONCATENATE("Upload by: ",TEXT(WORKDAY([@[Surgery Date]],-12,Holidays!A$4:$A$103),"dd-MMM"))),
IF(AND([@Material]="Wood",[@Manufacturer]="Germany"),HYPERLINK(CONCATENATE("https://website.com/ui/cases/",[@[Eng '#]],"/case-design"),CONCATENATE("Upload by: ",TEXT(WORKDAY([@[Surgery Date]],-16,Holidays!A$4:$A$103),"dd-MMM"))),
"")))),
"")
))))))

It should only hyperlink the last bit of the code.

The hyperlink also just takes my SharePoint.

What is causing this?

Thanks in advance!

 

[eli_m]

This is what the hyperlink looks like for the cell when other conditions are met:

The date shouldn't be hyperlinked at all