Formulas

RotorYacht

I'm Trying to add a function to the following formula in which adds "should the cell to the right of this formula show anything else except completed then the formula will display BEHIND

 

 

=IF(AND(TODAY() + 1 >= [Completion Due Date]29, [Days to Completion]29 < 100), "BEHIND", "")

Mike Wilday

Try this:

=IF(AND(TODAY() + 1 >= [Completion Due Date]@row, [Days to Completion]@row < 100, Status@row <> "Complete"), "BEHIND", "")

This should fire IF and only IF - Today + 1 is greater than or equal to the completion due date AND Days to completion is less than 100 and the status row doesn't say complete. 

 

RotorYacht

You are AMAZING!! Thank you so much it worked!! I'll buy you a beer!

 

Thanks,

Jay

Mike Wilday

Lol. Sounds good. Glad I got it working for you. 

Paul Newcome

?!?! How come no one ever offers to buy ME a beer?!?! 

 

Hahahahaha

Mike Wilday