To provide evaluation and monitoring data for multiple team members, I created linked Google Sheet files.
The Weekly Cohort Report files are styled to look like a form where Program Coordinators (Facilitators) respond to choice and open response questions. A hidden sheet pulls and summarizes data from the weekly sheets using IF, IFS, and IFCOUNT functions.
The Dashboard pulls data from multiple weekly report files to visualize summary data from each cohort. This provides an overview of each cohort’s progress and challenges for the Program Managers. It also provides communications, marketing, and evaluation data for other team members.
The files are connected using IMPORTRANGE and data validation checkboxes allow the Dashboard to show and hide data by student or week. These checkboxes link to ones in the Weekly Cohort Report and the relevant data is pulled through the QUERY function.