geekhack

geekhack Community => Other Geeky Stuff => Topic started by: fohat.digs on Thu, 26 June 2014, 10:33:26

Title: Google Spreadsheet cell value help
Post by: fohat.digs on Thu, 26 June 2014, 10:33:26

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!

Title: Re: Google Spreadsheet cell value help
Post by: fohat.digs on Wed, 02 July 2014, 17:28:31

Over 50 views and no responses?

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

Title: Re: Google Spreadsheet cell value help
Post by: SpAmRaY on Wed, 02 July 2014, 17:53:41

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

Title: Re: Google Spreadsheet cell value help
Post by: fohat.digs on Wed, 02 July 2014, 18:06:28

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

I appreciate the try.

Title: Re: Google Spreadsheet cell value help
Post by: CPTBadAss on Wed, 02 July 2014, 18:14:11

Quote from: fohat.digs on Wed, 02 July 2014, 17:28:31

Over 50 views and no responses?

A little impatient huh?

This link seems to have the answer you want. (https://productforums.google.com/forum/#!topic/docs/czyP7sMatIE) Try it out and let us know if it works.

Title: Re: Google Spreadsheet cell value help
Post by: fohat.digs on Wed, 02 July 2014, 19:21:33

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.