Email Notification on a date cell

Apologies if this has been previously discussed or in support already.

Is there a way to get smartsheet to send an email notification in say 1 month based on the date entered in the cell?

i.e. Went to a building site on the below date... smartsheet automatically sends me an email reminder in 1 month from this date to alert me to check the site again.

Find more posts tagged with

Accepted answers

Kelly Moore

Hey @Seb

Yes, you can have date based triggers. Below is a screenshot of an example. Note the trigger type has been changed to DATE IS REACHED. Use the highlighted dropdown to select 30days AFTER. You will need to select your specific Date Field column.

You may want a condition of when not to notify someone if the task is completed. You may have some criteria that indicates completion.

You will choose the Action 'ALERT SOMEONE'

Will this work for you?

Kelly

All comments

Kelly Moore

Hey @Seb

You may want a condition of when not to notify someone if the task is completed. You may have some criteria that indicates completion.

You will choose the Action 'ALERT SOMEONE'

Will this work for you?

Kelly

Kelly Moore

Seb108

Many thanks Kelly! I have done the following and will test it out. Really appreciate your quick and detailed response!

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.