Need to add an "OR" function to my formula

Hello.

I am currently using this formula to "flag" my At Risk column:

=IF(AND([End Date]@row <= TODAY(7), [End Date]@row >= TODAY(), [% Complete]@row <> 1), 1, 0)

It works great for the above but I need my flag to also turn red if/OR my Estimated Project Finish Date is beyond or greater than my End Date. Example: My project end date is set for 8/9/24 but my estimated end date is 9/3/24.

How do I add the "OR" function to this so it works properly?

Find more posts tagged with

Accepted answers

Nic Larsen

Try:

=IF([Estimated Project Finish Date]@row > [End Date]@row, 1, IF(AND([End Date]@row <= TODAY(7), [End Date]@row >= TODAY(), [% Complete]@row <> 1), 1, 0)

All comments

Nic Larsen

Try:

=IF([Estimated Project Finish Date]@row > [End Date]@row, 1, IF(AND([End Date]@row <= TODAY(7), [End Date]@row >= TODAY(), [% Complete]@row <> 1), 1, 0)

Devin Lee

You can nest IF statements together to check for one condition and then the other.

=IF([Estimated Project Finish Date]@row > [End Date]@row, 1, IF(AND([End Date]@row <= TODAY(7), [End Date]@row >= TODAY(), [% Complete]@row <> 1), 1, 0))

beckyw

Thanks, @Nic Larsen and @Devin Lee ! You both provided the same formula and it works great! Thanks for the quick response as well!

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.