Need to add an "OR" function to my formula

Options

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?

Best Answer

  • Nic Larsen
    Nic Larsen ✭✭✭✭✭✭
    Answer ✓
    Options

    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)

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!