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?
Comments
-
Hi Jim,
You'll want to create a Reminder that is based off of a date column and contact column. More information on this is available in our Help Center: https://help.smartsheet.com/articles/542913-using-reminders
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!