« previous next »
Pages:  [1]     Go Down

Author Topic: Google Spreadsheet cell value help  (Read 1558 times)

0 Members and 1 Guest are viewing this topic.

Offline fohat.digs

  • * Elevated Elder
  • Thread Starter
  • Posts: 6533
  • Location: 35°55'N, 83°53'W
  • weird funny old guy
Google Spreadsheet cell value help
« 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!
Logged
"However, even though I was born in the Mesozoic, I do know what anyone who wants to reach out to young people should say: Billionaires took your money. They took your chance to buy a home. They took your chance at a good education. They stole your opportunities. Billionaires took the things you want in life. If you really want those things, you have to take them back.
That's the message. That's the whole message. Say that every day, not just to reach America's frustrated young white men, but people of every age, race, and gender.
Late-stage capitalism is a wealth-concentration engine, focused on vacuuming up every dollar and putting it in as few hands as possible. Republicans are helping that vacuum suck.
How does a tiny fraction of the population get away with this? They do it by dividing the other 99% of Americans against themselves."
- Marc Sumner 2025-05-30

Offline fohat.digs

  • * Elevated Elder
  • Thread Starter
  • Posts: 6533
  • Location: 35°55'N, 83°53'W
  • weird funny old guy
Re: Google Spreadsheet cell value help
« Reply #1 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?
Logged
"However, even though I was born in the Mesozoic, I do know what anyone who wants to reach out to young people should say: Billionaires took your money. They took your chance to buy a home. They took your chance at a good education. They stole your opportunities. Billionaires took the things you want in life. If you really want those things, you have to take them back.
That's the message. That's the whole message. Say that every day, not just to reach America's frustrated young white men, but people of every age, race, and gender.
Late-stage capitalism is a wealth-concentration engine, focused on vacuuming up every dollar and putting it in as few hands as possible. Republicans are helping that vacuum suck.
How does a tiny fraction of the population get away with this? They do it by dividing the other 99% of Americans against themselves."
- Marc Sumner 2025-05-30

Offline SpAmRaY

  • NOT a Moderator
  • * Certified Spammer
  • Posts: 14667
  • Location: ¯\(°_o)/¯
  • because reasons.......
Re: Google Spreadsheet cell value help
« Reply #2 on: Wed, 02 July 2014, 17:53:41 »
Logged

Offline fohat.digs

  • * Elevated Elder
  • Thread Starter
  • Posts: 6533
  • Location: 35°55'N, 83°53'W
  • weird funny old guy
Re: Google Spreadsheet cell value help
« Reply #3 on: Wed, 02 July 2014, 18:06:28 »
Thanks, Ray, but the Excel method does not work in Google Spreadsheets.

I appreciate the try.
Logged
"However, even though I was born in the Mesozoic, I do know what anyone who wants to reach out to young people should say: Billionaires took your money. They took your chance to buy a home. They took your chance at a good education. They stole your opportunities. Billionaires took the things you want in life. If you really want those things, you have to take them back.
That's the message. That's the whole message. Say that every day, not just to reach America's frustrated young white men, but people of every age, race, and gender.
Late-stage capitalism is a wealth-concentration engine, focused on vacuuming up every dollar and putting it in as few hands as possible. Republicans are helping that vacuum suck.
How does a tiny fraction of the population get away with this? They do it by dividing the other 99% of Americans against themselves."
- Marc Sumner 2025-05-30

Offline CPTBadAss

  • Woke up like this
  • Posts: 14383
    • Tactile Zine
Re: Google Spreadsheet cell value help
« Reply #4 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. Try it out and let us know if it works.
Logged

Offline fohat.digs

  • * Elevated Elder
  • Thread Starter
  • Posts: 6533
  • Location: 35°55'N, 83°53'W
  • weird funny old guy
Re: Google Spreadsheet cell value help
« Reply #5 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.
Logged
"However, even though I was born in the Mesozoic, I do know what anyone who wants to reach out to young people should say: Billionaires took your money. They took your chance to buy a home. They took your chance at a good education. They stole your opportunities. Billionaires took the things you want in life. If you really want those things, you have to take them back.
That's the message. That's the whole message. Say that every day, not just to reach America's frustrated young white men, but people of every age, race, and gender.
Late-stage capitalism is a wealth-concentration engine, focused on vacuuming up every dollar and putting it in as few hands as possible. Republicans are helping that vacuum suck.
How does a tiny fraction of the population get away with this? They do it by dividing the other 99% of Americans against themselves."
- Marc Sumner 2025-05-30
Pages:  [1]     Go Up
« previous next »