We created a new sheet for tracking our work and have a cell with a due date for design submittals. There is an empty cell next to the due date that we want the user to add either a check box or date to show the submittal was actually done. The question is, if the date or checkbox isn't filled out after the due date has passed, is there a way to send an automatic notification to contacts on the team (managers) so we know the work is late?
