Wednesday, August 28, 2013

yogi_Set Up Formula To Print Only Chosen Cells Within A Google Spreadsheet

                                          Google Spreadsheet   Post  #1347
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug 28, 2013
user felin (http://productforums.google.com/forum/?zx=rjvzs6hyvk66#!mydiscussions/docs/bV54mfIHJk4)
How do I create a formula(s) to print only chosen cells within my Google Spreadsheet??
Hello there.

I just created a fairly complicated (to me anyhow) chore sheet for my family.

There are 3 of us who share in and trade off on the chores so that is what makes it complicated. If I can attach it here I will. Not sure if am allowed to do that.

I did one whole month at once. Each week is a little bit different.

Here is what I'd like to be able to do if it is possible.

For my daughter, for eg., I'd like to be able to create some formula that would allow me to see only her chores and all of the dates that correspond, etc. and THEN be able to print only one of the weeks at a time. I do not know how to operate formulas so am pretty lost.

PLEASE help if you can.

Really need this ability so that I can print each persons own personal chore sheet out each week.

Thanks so much!!

---
https://docs.google.com/spreadsheet/ccc?key=0AvksLP1rHERpdHNEbEstQjRGRTExRnNqLW45cHRYTWc&usp=sharing
-------------------------------------------------------------------------------------------------------