Need to add an "OR" function to my formula

beckyw · 06/04/24

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?

Nic Larsen · 06/04/24

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)

Nic Larsen · 06/04/24

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 · 06/04/24

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 · 06/04/24

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

Formulas and Functions

Formulas and Functions

Need to add an "OR" function to my formula

Best Answer

Answers

Help Article Resources

Quick Links

Categories

Trending in Formulas and Functions

Finding if a date falls in a range in a referenced sheet

CountIF contains name from a contact list help needed

Formula for averaging days