Reminder-update request

Hi everyone,

I have a formula in my Smartsheet that shows 5 workdays from the submission date.

I have an automation setup to send a reminder to the Quality Engineers when a date is reached. Is there a way to be specific, such as when the 5 Day Reminder date is reached, where the condition is that the complaint is open?

I have it just as a random date is reached, where the complaint is open and the 5 Day Reminder is not in the future.

Is that the best way to do that?

Freda

Find more posts tagged with

Accepted answers

All comments

Paul Newcome

I usually set it up to run daily with a dual condition of the reminder date is today and the status is not closed, but if you have the reminder date column set as a date type column and housing date type data, you should be able to set your automation up to run off of the date column.

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, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.