I created a Google Sheets to track the status of our unit’s summer camp participants. This Google Sheets reflects the status of our participants and includes most, if not all, of the questions needed during summer camp registration and check-in.
You can find the tracker here: https://docs.google.com/spreadsheets/d/1mefasRXQoU-0-HdxY9DSA193fXNY41DLioNjQAmPTG0/edit?usp=sharing and you can make your own copy by clicking “File – Make a copy” if you are signed in to Google.
Many of the columns are color coded based on status. To change the formulas, color, or other options, simple select the column then click on “Format – Conditional Formatting” from the menu bar.
Form the medical form tracker, see this post: https://www.johndball.com/easily-track-scouts-bsa-medical-form-youth-protection-training-and-photo-release/