Tuesday, October 23, 2012

yogi_Create A SisterSheet To Pull Data In DayOfSupport TeamMember And SubjectArea Columns For Current Week (starting on Monday)

Yogi Anand, D.Eng, P.E.      Google Spreadsheet   Post  #822  Oct 23, 2012    www.energyefficientbuild.com.

user Syndy212 said: (http://productforums.google.com/forum/?zx=jro1h3a5xnh2#!category-topic/docs/spreadsheets/AXogKDhnfVc)
I need to figure out how to make the sister sheet to pull the data once a week from the form responses, 
only pulling the responses the schedule activity for the coming week - that is the DAY OF SUPPORT column. (in date order)
"Weeks" open on Monday and close on Friday.
Not all data is needed - like we don't need the timestamp, for example. 
That would solve so many problems that it is almost too good to be true that it could happen! 
following is a solution to the problem