Hey knowledgeable ones!,
I'm working on a sheet that is already nice to have, but I want to go above and beyond, if it's possible with Excel of course.
The goal is to have a "Roster" of people, and a cell categorized for each person as the following;
- Hours This Month
- Total Hours
- Total Commendations
- Roll Call (For the active Month)
The goal for each is explained below;
Hours of the Month, somebody submits a Form, it goes to the responses Sheet in my drive, the goal is to have the Roster check and pull each person's accumulative hours for the current month and display it for everyone else to see. (Hopeful to have it automatically update the Month and either have a button to clear the hours for the person or automatically when it updates it just clears the cells and puts them at 0)
Total Hours, somebody submits a Form, it goes to the response Sheet in my drive, the goal is to have to tally that person's total hours regardless of the Month.
Total Commendations, much the same people submit forms and it goes to the sheet, but it tallies a total for that person and displays it.
Roll Call, the goal is a person submits their Roll Call for the Month and the Roster displays it has having been submitted, then at the end of the Month it clears it to not being submitted so that the next form can be.
If any of these are possible please let me know, I currently have the Roster Sheet, a Database sheet which is logging Information through IMPORTRANGE function, and a Form Linked Sheet with the master list of replies, the Database is meant for visual logging to make it easier to see, the sheet I use to import data is the Form Sheet. I hope my explanations didn't suck and y'all can help me figure something out, even if it's not exactly.
Bookmarks