Google Spreadsheet cell value help

[fohat.digs]

Is there a simple way to make the value of a cell equal the file name?

I can find how to make it equal the tab, or how to do it in Excel, but I simply want the filename itself as the content of the cell.

Thanks!

[fohat.digs]

Over 50 views and no responses?

If anybody knows that this cannot be done, will you at least tell me that much?

[SpAmRaY]

http://office.microsoft.com/en-us/excel-help/insert-the-current-excel-file-name-path-or-worksheet-in-a-cell-HA010342623.aspx

[fohat.digs]

Thanks, Ray, but the Excel method does not work in Google Spreadsheets.

I appreciate the try.

[CPTBadAss]

Over 50 views and no responses?

A little impatient huh?

This link seems to have the answer you want. Try it out and let us know if it works.

[fohat.digs]

I have been through a lot of avenues, with no success.

I am not interested in cell values that equal sheet names, I want the filename of the spreadsheet itself.

For some reason, Google makes that very difficult.

Like so many other things, their stuff is great, in a vacuum, but not designed by people with real-world experience and needs.