Monday, April 25, 2016

yogi_From Data In 'Form responses' Sheet Compute Stats By Day_Of_Week Week_To_Date Month_To_Date Year_To_Date

Google Spreadsheet   Post  #2061
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Apr-25-2016
question by: zohair92:!topic/docs/MIHesvfztQE;context-place=forum/docs

Form Responses Sheet (From a Google Form) ->Organizing Into Periodical Tabs (Weekly...etc)

 Hello all, 

I have a Google Form which tracks three kinds of warranties sold by my employees. 

Naturally, the responses to the form go to a Google Doc Sheet. The Form tracks the following information: The date/time, the employee name, and the warranty sold. What I would like to do is have a tab for Daily results (Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday), a tab for Week to Date Results, a tab for Month to Date Results, and a Tab for Year to Date results.  

Essentially, I'm wondering if there is a way to automatically filter the raw data by using a calendar format? So I would like the current week to be displayed in the Daily Results Tabs.  In the Week To Date tab, I would like it to tally up the results for the week based on the day of the week (so if its wednesday, tally up monday+tuesday+wednesday). Sort of a live tracking system. 

I know it sounds complicated, so I've uploaded a sheet as an example of what I want to see. 

Please ive been struggling with this. If you need more information please let me know!

Thank you!!