I have a Google sheet that logs all submissions on my website of various contact forms. I need to know how many times each contact form has been submitted, and in which week they were submitted.
The goal is to have a Google sheet to look like this: (Each tab in the Google sheet is the same name of these forms)
Week Commencing | Number of Submissions
1st July 2019 | 37
8th July 2019 | 7
The data I have looks like this: (in a tab named "data")
form name | date
Custom Printed Premium Gift Boxes | 7/4/2019 12:01:28
Link to google sheet: https://docs.google.com/spreadsheets/d/1ffOVvGT7CGV3gXR1HP5kp6Pg1JgD40qRjlt6lwwFbo0/edit?usp=sharing
My questions:
- How do I count the submissions from the data tab and put the total, by the week, into the correct tab?
- How do I get the week number, convert it to a correct row title of "1st July 2019" and then have the number of submissions for that very week go into the correct cell?
- Is there a better way to achieve what I'm doing? Am I square peg/round hole-ing?