Creating A Report of Missing Submissions

Cshannon

Hi Community!

I have a form deployed to community partners. These partners need to submit a report 1x per month. Of course, some do not submit the monthly report. Is there a way for me to create a report of missing submissions? I have a reference of all partners who should be submitting a report and the sheet from the form of all submissions for all months. How can I create a report that provides a basic output of who is missing their submission each month?

Thank you for your assistance and consideration of this problem!

Julie Fortney

Hi @Cshannon. You could add reporting columns on your partner reference sheet for each month, then count the number of submissions for that partner in the given month.

Here's an example partner reference sheet:

Formula for September 2024:

=COUNTIFS({10.14.24 Partner Reports Partner Name}, [Partner Name]@row, {10.14.24 Partner Reports Submission Date}, AND(@cell > DATE (2024, 8, 31), @cell < DATE(2024, 10, 1)))

Formula logic: count the number of rows with a partner name that equals the Partner Name on this row, with a Submission Date in September 2024.