Welcome to the Smartsheet Forum Archives

The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.

Due Date is Past Due - Checkbox

Cindi Rella
edited 12/09/19 in Archived 2016 Posts

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
    edited 10/26/16

    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")

  • Had a co-worker help me and we got it working!!

    =IF(AND(([Adj End Date]14 - TODAY()) < 0, NOT([% Complete]14 = 1)), "True", "False")

This discussion has been closed.