Author Topic: Google Sheets help  (Read 1313 times)

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9168
  • Total likes: 254
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #15 on: November 05, 2018, 02:21:05 PM »
Looked through this? You're using the default () value instead of putting in the reference you need.

https://support.google.com/docs/answer/3093373?hl=en
Thanks for answering! I hadn't seen that. The reason I'm not putting in the reference I need is because I want to use the INDIRECT function to refer to a cell a few columns over, and I want each column to have a different result. Do you know a better way to get the value of a cell a certain # of columns over?
Workflowy. You won't know what you're missing until you try it.

Offline lubaby

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Jun 2010
  • Posts: 4196
  • Total likes: 160
  • DansDeals.com Hat Tips 12
  • Gender: Male
    • View Profile
  • Location: New York
  • Programs: Hertz PC, National EE
Re: Google Sheets help
« Reply #16 on: November 05, 2018, 03:26:08 PM »
Thanks for answering! I hadn't seen that. The reason I'm not putting in the reference I need is because I want to use the INDIRECT function to refer to a cell a few columns over, and I want each column to have a different result. Do you know a better way to get the value of a cell a certain # of columns over?
Maybe OFFSET.

https://support.google.com/docs/answer/3093379?hl=en
« Last Edit: November 05, 2018, 03:32:30 PM by lubaby »
Once the game is over, the king and the pawn go back in the same box.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9168
  • Total likes: 254
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #17 on: November 05, 2018, 04:17:45 PM »
Maybe OFFSET.

https://support.google.com/docs/answer/3093379?hl=en
It looks like OFFSET needs you to provide the address of the current cell (or the cell to refer to) - how do I tell it to use the cell that the result is displayed in, rather than the cell that the formula is in?
Workflowy. You won't know what you're missing until you try it.

Offline as2

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4175
  • Total likes: 394
  • DansDeals.com Hat Tips 19
  • Gender: Male
    • View Profile
  • Location: Milky Way - Just near that big yellow one
  • Programs: Loyalty: A bunch. Government: None! Looking for a job that pays cash.
Re: Google Sheets help
« Reply #18 on: December 06, 2018, 10:52:55 AM »
Looking for some help with a basic formula. I have a spreadsheet that has a name in column A and a balance in column B. My goal is to have column C give me a specific percentage of the cell in column B. Is there a general formula that means "the previous cell in this row" or do I need to manually adjust the formula for each cell in the column?
Memories last forever, make them while you can.

Offline davidrotts63

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: May 2017
  • Posts: 5154
  • Total likes: 444
  • DansDeals.com Hat Tips 18
  • Gender: Male
    • View Profile
Re: Google Sheets help
« Reply #19 on: December 06, 2018, 10:54:45 AM »
When you paste it below it should follow the pattern
(Quit) pulling out the flowers, and watering the weeds. -Peter Lynch

Offline as2

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4175
  • Total likes: 394
  • DansDeals.com Hat Tips 19
  • Gender: Male
    • View Profile
  • Location: Milky Way - Just near that big yellow one
  • Programs: Loyalty: A bunch. Government: None! Looking for a job that pays cash.
Re: Google Sheets help
« Reply #20 on: December 06, 2018, 11:00:49 AM »
When you paste it below it should follow the pattern
Can you elaborate please? Sorry, all of my excel/sheets knowledge is self taught and very basic. I usually use formulas to output a number from multiple cells to a single cell, I never use it for multiple to multiple.
Memories last forever, make them while you can.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9168
  • Total likes: 254
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #21 on: December 06, 2018, 11:04:35 AM »
Looking for some help with a basic formula. I have a spreadsheet that has a name in column A and a balance in column B. My goal is to have column C give me a specific percentage of the cell in column B. Is there a general formula that means "the previous cell in this row" or do I need to manually adjust the formula for each cell in the column?
In C2, put =B2*0.5 (if you want 50%, you can change that to whatever you need). Then copy that cell and paste it to the entire column and it will automatically modify the row numbers as needed.
Workflowy. You won't know what you're missing until you try it.

Offline as2

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4175
  • Total likes: 394
  • DansDeals.com Hat Tips 19
  • Gender: Male
    • View Profile
  • Location: Milky Way - Just near that big yellow one
  • Programs: Loyalty: A bunch. Government: None! Looking for a job that pays cash.
Re: Google Sheets help
« Reply #22 on: December 06, 2018, 11:08:15 AM »
When you paste it below it should follow the pattern
In C2, put =B2*0.5 (if you want 50%, you can change that to whatever you need). Then copy that cell and paste it to the entire column and it will automatically modify the row numbers as needed.
Thanks!
Memories last forever, make them while you can.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9168
  • Total likes: 254
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #23 on: December 06, 2018, 11:09:25 AM »
Or you can paste this into C2 and it will fill down automatically
=arrayformula(B2:B*0.5)
Workflowy. You won't know what you're missing until you try it.

Offline as2

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: Mar 2013
  • Posts: 4175
  • Total likes: 394
  • DansDeals.com Hat Tips 19
  • Gender: Male
    • View Profile
  • Location: Milky Way - Just near that big yellow one
  • Programs: Loyalty: A bunch. Government: None! Looking for a job that pays cash.
Re: Google Sheets help
« Reply #24 on: December 06, 2018, 11:59:39 AM »
Or you can paste this into C2 and it will fill down automatically
=arrayformula(B2:B*0.5)
Thanks. Ended up putting the formula in and auto filling down the column.
Memories last forever, make them while you can.

Offline etech0

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Dec 2013
  • Posts: 9168
  • Total likes: 254
  • DansDeals.com Hat Tips 1
    • View Profile
  • Location: not lakewood
  • Programs: DDF
Re: Google Sheets help
« Reply #25 on: December 06, 2018, 12:04:35 PM »
Thanks. Ended up putting the formula in and auto filling down the column.
Great!
Workflowy. You won't know what you're missing until you try it.