Flag is true when status is not complete and date modified is 5 days old

Hello, in an effort to automate update request emails for items that have been stuck at a specific status for a period time, I am trying mark a flag as true when the row status is not complete, and the date modified is more than 5 days old.

I think I need an IF And formula and having difficulty incorporating the and statement. Does anyone have any recommendations?

Find more posts tagged with

Accepted answers

Mark Cronk

=IF(AND(NOT(staus@row="Complete"), Modified@row<today(-5)), 1, 0)

Mark

All comments

Mark Cronk

=IF(AND(NOT(staus@row="Complete"), Modified@row<today(-5)), 1, 0)

Mark

Michael D.

Thanks Mark, worked perfectly! Now I just set up conditions in my update request for when this field is changed.

Thanks for the help!

Mark Cronk

Hi Michael, Happy to help. Thank you for contributing to the Community.

Mark

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.