Formula to Trip a Flag

Hello,

I currently have a formula in my sheet that trips the Flag function in my "At Risk" Column if the due date is less than today, and the status is NOT waived. The formula below works great. However, I would like to include "PFiled" and "Efiled" to the status already referenced, but I'm stuck. Can you please assist?

=IF(AND([End Date]110 < TODAY(), NOT(Status110 = "Waived")), 1, 0)

Find more posts tagged with

Accepted answers

Paul Newcome

Try using an OR function nested within the AND function.

=IF(AND([End Date]@row < TODAY(), OR(Status@row <> "Waived", Status@row <> "PFiled", Status@row <> "Efiled")), 1, 0)

All comments

Andrée Starå

Hi Michele,

Where are the PFiled and Efiled values located?

Edit: I noticed that you mentioned status. Then Pauls formula below should work.

I hope that helps!

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant / CEO @ WORK BOLD

✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Paul Newcome

Try using an OR function nested within the AND function.

=IF(AND([End Date]@row < TODAY(), OR(Status@row <> "Waived", Status@row <> "PFiled", Status@row <> "Efiled")), 1, 0)

Michele Phillips

Hi Paul -

Thanks for reaching out! I copied and pasted your formula into one of the cells in the At Risk column that had Waived and Pfiled as the Status and it didn't work. However, after tweaking it for a bit, I got it to work using this:

=IF(AND([End Date]@row < TODAY(), AND(Status@row <> "Waived", Status@row <> "PFiled", Status@row <> "Efiled")), 1, 0)

Thanks so much for your help, as you at least pointed me in the right direction.

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.