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...
=IFERROR(HYPERLINK(CONCAT(http_to_Master_Folder,"%2F%5F%5FCharacter%2FCY",TEXT(RIGHT(MONTH_YEAR,4),"0000"),"%2FNotes&viewid=x00000f2%2X0x0x%2XD0xxx%0Xx00x%0X0000x000xx00"),CONCAT("Game > Campaign > Player > Character > CY", TEXT(RIGHT(MONTH_YEAR,4), "0000"), " > Notes")), CONCAT("Game > Campaign > Player > Character > CY", TEXT(RIGHT(MONTH_YEAR,4), "0000"), " > Notes"))
Just off the top of my head, maybe it helps, if not please just ignore it 🙂.