What participants are Missing From the Google FormтДв submissions? Match a list of expected participant emails with submitted Email Addresses to a Google FormтДв.
This is a Google SheetsтДв Add-on for the Form Responses from a Google FormтДв. The Form must require email addresses. Insert a sheet into the Form Responses with a list of the expected participants. One of the columns MUST contain email addresses and have a column header that contains the word email. Missing From by Alice Keeler automatically detects the Email Addresses column on the Form Responses tab and matches it to the email column in the active sheet.
AliceKeeler Select the Cells is created by Google Developer Expert Alice Keeler. It collects NO user data. NO PII. Check out more of her Add-ons at http://alicekeeler.com/codedbyalice
Note: The Form Responses tab must start with the word Form.