Is there a FORMULA that will display the name of the file in a cell?
I've found scripts that will do it, formulas that will display the sheet name, but no luck finding a formula that will show the filename.
If I have to resort to the script, so be it. But I'd like to use formula if possible.
If this has been asked before, please point me to the post and I will delete this one.
No—unfortunately this is not possible with any built-in function.
The only way to do this with a function would be to use AppScript to write a custom one, which is essentially back to writing a script.