Google Spreadsheet Post #2061
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Apr-25-2016
question by: zohair92:
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/MIHesvfztQE;context-place=forum/docsForm 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!!
Zohair
https://docs.google.com/
---------------------------------------------------------------------------------------------------
No comments:
Post a Comment