I have a spreadsheet that manages my mods for a steam game. Each mod has an ID which i store in Column C, and steam saves each mod in its workshop folder in a separate folder with the ID number as name.
So for example the MOD mymod (ID 123456789) is located at “E:\GAMES\Steam\steamapps\workshop\content\244850\123456789” (244850 is the ID of the game which will remain the same)
Now, i want to be able to open the FOLDER in my windows explorer for a mod from a spreadsheet. I tried the hyperlink function :
=HYPERLINK(CONCATENATE("E:\GAMES\Steam\steamapps\workshop\content\244850\";T(C:C) ;"\"); "OPEN")
While it doesn’t throw any errors and displays ‘OPEN’ in each row as expected, there is no hyperlink functionality for the cell (ie i can’t ctrl+click OPEN to open the folder).
What am i doing wrong?