I use google forms to capture attendance into a google sheet. I would like to be able to calculate how many students attended between certain dates eliminating any duplicate names (for instance only counting a student once even if they were present multiple times within that time frame). I would also like to calculate how many students are new during that time frame as well.
so an example would be if the app had a form where someone could pick points in time (January 1 to December 31 for example) the app could tell them the number of students that attended in that time frame.
If this can be done how would I proceed with building such an app? I have never used AppSheet before.
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |