Need to add an "OR" function to my formula

beckyw

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

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

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!