Due Date is Past Due - Checkbox

Cindi Rella

I'm trying to write a formula that will "check" the checkbox if the Adj End Date is Past Due and the % complete is not 100%)

I started with just the Adj End Date portion and have not added the percent complete to the formula.

 

This isn't working...

 

=(IF(TODAY() > [Adj End Date]5,TRUE,FALSE)

 

I then want to do conditional formatting on it.

Cindi Rella

I changed the field to be a text box instead.  Now the issue is that everything is "TRUE".

 

I want it only to be "True" if the %Complete is not 100% and the Adj End Date has passed.  Here is what I have so far.

 

=IF(NOT([% Complete]73 <> 100), ([Adj End Date]73 < TODAY()), "True")