I know that I can get the spreadsheet name using a Google Apps Script custom function, but that does not work for me, because I need this function to work when I make a copy of the spreadsheet and once you make a copy, you have to authenticate the function and the person who will use that copy will not do that.
I need a native function that returns the name of the Spreadsheet. Apparently Excel has a function that does that =cell('filename',a1), but I could not find a similar function in Google Sheets. I suspect it does not exist, but you guys are way more clever than I am, so it is worth a shoot...
No—unfortunately this is not possible with any built-in function.