#Circular Reference

I am trying to create a workflow where if the "Pull Date" cell is in the next 14 days, the value in the Status column changes to "Upcoming". The workflow did not work.

So, Smartsheet AI suggested formula =IF([Pull Date]@row <= TODAY() + 14, "Upcoming", Status@row ). I put this formula in the Status cell and get #Circular Reference. Can anyone help me with this? I supposedly do not need Bridge to make this work.

Status Workflow.png

Find more posts tagged with

Formulas

Workflows in Smartsheet

Accepted answers

All comments

Paul Newcome

You need to put the formula into a different column. You cannot have a reference to the same cell the formula is in within the formula itself.

How exactly are you populating [Pull Date]?

Dina B

@Paul Newcome The Pull Dates are manually entered. The Status column is a drop down that is also manually entered. I want the Status to change from Pending to Upcoming if the Pull date is in the next 14 days.

Paul Newcome

Ok. The automation should have worked. Try setting it to run at 1am.

Dina B

@Paul Newcome I will try that and let you know. 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.