automatic notifications when dates are passed

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?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!