Assistance Needed with Date Archiving Automation

Hi there,

I have a helper sheet that populates Office drop-down dates via DataShuttle. The "Date Requested" column contains drop-down options with dates, and the "Date" column is a date column (my trigger for moving rows.

I want to archive each date row if it matches today’s date, but the automation I set up isn’t moving the rows as expected.

Could you help me troubleshoot this?

Thanks!

Automation what I have:

Do I need to include the offices too as part of the condition?

These are the offices:

Find more posts tagged with

Automations

automated archive

Accepted answers

Darla Brown

@Brittanyy another option would be to add a checkbox helper column. If "Date" is Today, check box. Then that could be your trigger.

All comments

Darla Brown

Hi,

Have you tried using the Date column as your trigger instead of "every day starting…"? I don't think you need the offices as part of your condition.

Brittanyy

@Darla Brown I have tried that method too, but it didn't work.

Darla Brown

@Brittanyy another option would be to add a checkbox helper column. If "Date" is Today, check box. Then that could be your trigger.

Brittanyy

@Darla Brown I'll try that.

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.