Hi, i'm kind of going in circles. I'm pretty good at watching training videos and learning how to do most things in Excel. I am kind of unsure how to phrase what I'm trying to do. Looking for some direction.
I created a digital form that sends responses to a google sheet. (I am including a sheet example of responses). That same sheet also uses a Query function to find it's "Area" via vlookup. The responses are Opening Checklist, Closing Checklists, etc.
What I want to show is the Group percentage completion for Opening checklists for today. For instance, Huston Area 90%. The formula would look for Opening checklist completed by all his Stores in his area. I would need to be able to do this for each day, as it is a recurring task. I hope this makes sense, I couldn't explain it very well in youtube search box. Even if you can just advise me on what to search for to train, that would be great. Thank you
Sorry for the mess
https://drive.google.com/open?id=1y0fTOAnvlh4q2YT5DPqK2Qd9OwQ4yvDw
I created a digital form that sends responses to a google sheet. (I am including a sheet example of responses). That same sheet also uses a Query function to find it's "Area" via vlookup. The responses are Opening Checklist, Closing Checklists, etc.
What I want to show is the Group percentage completion for Opening checklists for today. For instance, Huston Area 90%. The formula would look for Opening checklist completed by all his Stores in his area. I would need to be able to do this for each day, as it is a recurring task. I hope this makes sense, I couldn't explain it very well in youtube search box. Even if you can just advise me on what to search for to train, that would be great. Thank you
Sorry for the mess
https://drive.google.com/open?id=1y0fTOAnvlh4q2YT5DPqK2Qd9OwQ4yvDw
