Day based Reminder

Hi there ;

İ would like to set a workflow as below ; how can i manage ?Could you help me pls

i have a date column named "date" and i have one more column named " material" ;

i want that system will send an alert according to below rules :

--Alert will start 2 weeks later from date column

--İf material column is blank send this alert every week on monday with never end , reminding couls stop when material column will be blank.

Thanks for your kind supports

Erhan

Find more posts tagged with

Workflows in Smartsheet

Accepted answers

Genevieve P.

Hi @Automatic Mail

The way to do this is to set a Date-Based Workflow, see: Create a Time-Based Automated Workflow.

You will want to set a custom recurrence, sending every Monday:

Screen Shot 2021-12-02 at 12.31.05 PM.png

Screen Shot 2021-12-02 at 12.30.45 PM.png

Then set a Condition Block in your workflow to look for a Date in the Past, but that's not within the last 14 days, and also that the other column is Blank. See: Condition Blocks: Filter What Your Automated Workflows Send

Screen Shot 2021-12-02 at 12.34.52 PM.png

Let me know if this works for you!

Cheers,

Genevieve

All comments

Genevieve P.

Hi @Automatic Mail

The way to do this is to set a Date-Based Workflow, see: Create a Time-Based Automated Workflow.

You will want to set a custom recurrence, sending every Monday:

Let me know if this works for you!

Cheers,

Genevieve

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.