Forum Discussion
Sharepoint Hyperlink not Dynamic
Recently a bunch of items were moved from a drive to Sharepoint and I am trying to update my dynamic hyperlinks. Every month there is a checklist of tasks that need to be accomplished and I have Hyp...
I have tried this as I have a similar requirement coming up.
I broke it down into parts using a LET() statement and named ranges for the Root (parent) folders
=LET(yr,RIGHT(MONTH_YEAR,4), parent,shareFolder, yrFile, yr&"\DATA.XLSX", filePath, parent&yrFile, HYPERLINK(filePath, yrFile) )This works for me, so it may be worth rebuilding the formula to make sure that the hyperlink is correct