how to add the file path to spreadsheet

In Shortcuts app (in Applications > Utilities) create a shortcut like this:

This is done by dragging the Run AppleScript in, replacing whatever is in it with this:

tell application "Numbers" to set thePath to POSIX path of ((front document's file) as text)
set the clipboard to thePath

The click somewhere in the document, run the shortcut, and paste the path wherever you want it.

SG

Unfortunately there is no automated way in Numbers to do it, like you can do in Excel.

You would have to copy the path / filename from Finder in a text cell.

Potential you can do it with Automator / Scripts.

If you thing that more user would like to see this, you can send a feedback to Apple team.

Best case we get this in one of the next releases.

Product Feedback - Apple

Ralf