Workflow automation not following conditions

Hi,

I have this workflow automation I am trying to set up to move rows from an active sheet into an archived sheet, I want to move rows that are older than 35 days but not move the rows that have a created date that is 5/7/2025 as those rows have a couple of columns actively doing calculations. Here is the conditions I have currently set up. The "submission time" column is a date created column.

When I try and test run this automation it will move the rows that have the "5/7/25 12:53 PM" value into the archived sheet. How do I stop the automation from moving those rows with that specific date and only move the rows older than 35 days but exclude that date? Did I set this up incorrectly?

Find more posts tagged with

Workflows in Smartsheet

conditional logic

Accepted answers

All comments

Erin Horiuchi Green

Hello @Matthew Occena ,

Can you please take a screenshot of the Automation Trigger setup?

Matthew Occena

@Erin Horiuchi Green

Here is the Trigger. I dont think this is the issue since its based on time

I am just not sure where I went wrong in setting up the conditions for moving the rows

Erin Horiuchi Green

Hello @Matthew Occena,

Just for testing purposes…can you try the below. Sometimes I do use hidden helper columns to enable Automation or Formulas.

1) Create a "Test Created Date" Date Column that just captures MM/DD/YY from system column "Created Date". Use the formula DATEONLY().
2) Utilize "Test Created Date" in your Automation where "Test Created Date" is not one of "05/07/25" AND "Test Created Date" is not in the next (days) = 35.

Matthew Occena

Hi @Erin Horiuchi Green ,

Thank you for the solution, I am not sure why the original conditions set up wasn't working but with that helper column is works great now.

Matthew

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.