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

Options
Cindi Rella
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.

Tags:
· Share on FacebookShare on Twitter

Comments

  • Cindi Rella
    Cindi Rella ✭
    edited 10/26/16
    Options

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

    · Share on FacebookShare on Twitter
  • Cindi Rella
    Cindi Rella ✭
    Options

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

    · Share on FacebookShare on Twitter
This discussion has been closed.

Categories