Use IF And Statement to Flag

jcroft01

This formula works correctly:

=IF(AND([Date Created]2 < TODAY(-3), NOT(Status2 = "Completed")), 1, 0)

If a ticket was created more than 3 days ago and the status of the ticket is not completed, flag the cell. It works.

Now I need to add Duplicate in addition to Completed. No matter how I change it I always get an error.

=IF(AND([Date Created]1 < TODAY(-3), NOT(Status1 = "Completed", "Duplicate")), 1, 0) this gets an error.

Any Ideas?

Find more posts tagged with

Accepted answers

Frank S.

Greetings @jcroft01

Please try the following:

=IF(AND([Date Created]@row < TODAY(-3), NOT(OR(Status@row = "Completed", Status@row = "Duplicate"))), 1, 0)

I replaced the specific cell reference to the @row, so the formula can be used for the entire column.

I hope this helps and please let me know if you have any issues.

All comments

Frank S.

Greetings @jcroft01

Please try the following:

=IF(AND([Date Created]@row < TODAY(-3), NOT(OR(Status@row = "Completed", Status@row = "Duplicate"))), 1, 0)

I replaced the specific cell reference to the @row, so the formula can be used for the entire column.

I hope this helps and please let me know if you have any issues.

jcroft01

That did the trick. Thank you@Frank.Smith !!

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.