Forum Discussion

Copper Contributor

Oct 13, 2021

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...

Formulas and Functions

MVP

Oct 13, 2021

Try

=IFERROR("https://myDomain.sharepoint.com/sites/Sheets/Shared Documents/Driver/["&TEXT(A4,"yyyy-mm-dd")&"-4126 - Sheets.xlsx]Trip Expenses Sheet"!$A81, "")

DarrMik
Copper Contributor
Oct 14, 2021
HansVogelaar

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, "")
- HansVogelaar
  MVP
  Oct 14, 2021
  DarrMik
  
  I don't know anything about SharePoint; I hope that someone else can help you.
  - DarrMik
    Copper Contributor
    Oct 14, 2021
    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)

Resources