I would like to trigger a workflow based on a store opening date

@Paul Newcome I got this formula to work - =WORKDAY([Opening Date]@row, -30 to do the calculation. I think nothing worked as I am using predecessors. When I remove them it works but when I add them back th formula is no longer there.

Is there something I missing as the steps have clear dependencies. Not sure if there is a workaround if this is not possible

Paul Newcome

The circular reference error comes from putting the formula into a cell that it is referencing. You would have needed to put the formula into a different column.

You cannot use formulas in columns being used by the dependency settings. You would need to put the formula into a different column that is not being used by the dependency settings.

vanstadenster

Thanks @Paul Newcome - ok so if I put it in a different column, which I understand will work. Could it then trigger the start date to change which is used in dependency settings.

Sorry - still learning albeit a bit slow.

Paul Newcome

No. Columns being used by the dependency settings cannot be adjusted via formula or automation. You would need to leverage the API if you wanted to adjust something in one of those columns.

vanstadenster

Thank you!

Paul Newcome

Happy to help. 👍️

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.