404 - File or directory not found while using (external) open file

[draxdeveloper]

I am trying to open a file that is on a folder shared with me, I have access to the folder itself but it's not on my drive.
To do this, after I create the pdf file i register it on a file column using:
CONCATENATE(
"appsheet/data/BitPlot-OS-994462399/Files/" ,
CONCATENATE(
"OS_" ,
[registroOS].[os] ,
"_" ,
TEXT(NOW(),"DD-MM-YYYY_HH-MM-SS")
) ,
".pdf"
)

I tried to replace "appsheet/data/BitPlot-OS-994462399/Files/" for ""my-drive/appsheet/data/BitPlot-OS-994462399/Files/" , "Files/" and "" but nothing works.

I know the file exists and I know the path of the file is "appsheet/data/BitPlot-OS-994462399/Files/" but it's not working.

Also:

CONCATENATE(
"OS_" ,
[registroOS].[os] ,
"_" ,
TEXT(NOW(),"DD-MM-YYYY_HH-MM-SS")
) ,
".pdf"
)

Is how I generate the filename and I am not using a timestamp

[Marc_Dillon]

The file path value that goes into the column should be a relative path to the file, from the location of that table's gsheet. So, likely, you just need to reduce your "appsheet/data/BitPlot-OS-994462399/Files/" part, to just "Files/". However that's assuming your GSheet lives in the "appsheet/data/BitPlot-OS-994462399/" directory.