How to automatically display file path in a cell

I want to display the path to my spreadsheets, so that when I print them out, they can be found on a large system, so it is logical to automatically display the path to the file so that others looking at the page can find the entire spreadsheet.

I keep my brewing records as spreadsheets with 21 layers and the first layer is a summary to print out, which needs to have the location of the file automatically printed. The filename is autmatically generated on first save, but I need the path as well. I use the same spreadsheet for all brews, so there is not a single location to manually trype in, thus each spreadsheet should know where it is when it is printed.

I use Linux Mint operating system.

David

=LEFT(CELL("filename"),FIND("#$",CELL("filename"))-1)

Thank you so much for your kind and prompt reply!

David

If the answer solves your question please tick the :heavy_check_mark:.