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,
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!
Gratefully,
Syndy
---------------------------------------------------------------------------------------------
following is a solution to the problem
