Skip to content
  • Try for free

    • Archived 2016 Posts

    Archived 2016 Posts

    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

    ✭✭
    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

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

      · Share on FacebookShare on Twitter
    • ✭✭

      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.

    Quick Links

    Categories

    Trending Posts