A notification to be sent if a row of data is missing.
For our Master Cleaning Schedule sheets, starting with Daily, we are looking for a notification to be sent if a row of data is missing. For the Daily frequency, we are looking for a line item for all 5 areas (Dry, Cooler, Freezer, Exterior, Battery) to have been submitted each day. Therefore, each date should have 5 rows. In the example shown below, there are only 4 rows (Exterior is missing) submitted on a given date. We would want a notification to be sent around 5pm that same day to remind the supervisor that data is missing.
Thanks in advance