Automation - Moving to a row to a new sheet once a date has passed

Hi,

I need help with some automation. I want to move a row to a new sheet once 2 weeks have passed. This is due to a report we have on newly completed vs. historical completed items. Is automation based in calendar or business day?

For some reason, my automation does not consistently work. I have tried this automation:

I have also tried running this rule when dates are added or changed in the date completed filed and are not in the last 10 days. Neither of the run consistently.

Thanks for the help!

Find more posts tagged with

Automations

Accepted answers

AravindGP

Hi There,

Automation runs on calendar days. If you would like for the row to be moved 10 days after the Date Completed, your trigger would be "When a date is reached", after the "Run Once" dropdown, where you have a dropdown for "On", change it to "2 weeks after" and select your "Date Completed" in the Date field as you've already done.

There's no need for any conditions here as the workflow will work only 2 weeks after the date added in the Date Completed field. If there's no date or if the date is within 2 weeks, the workflow won't even run.

All comments

AravindGP

Hi There,

Stwillis

This worked, thank you!

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.