Forum Discussion
Build https link within formula using Cell value
Using Excel Online. I am pulling information into sheets in my current workbook from a separate excel file via web link: A2=IFERROR('https://myDomain.sharepoint.com/sites/Sheets/Shared Docume...
Still giving the same error....Excel is highlighting this section when I hit OK:
=IFERROR("https://mydomain.sharepoint.com/sites/Sheets/Shared Documents/Driver/["&TEXT(A4,"yyyy-mm-dd")&"-4126 - Sheets.xlsx]Trip Expenses Sheet"!$A81, "")
I don't know anything about SharePoint; I hope that someone else can help you.
- Not sure that sharepoint is at issue....my original link above works perfectly.
I was just hoping to be able to use a cell's value as the date portion of the link so that I can have the link change based on the value of the date cell (A4)