Using IF, AND, OR

Options
@SPark
@SPark ✭✭✭

Looking for formula advice/help! I would like to write a formula that will:

  • Mark Past Due if Complete By is greater than today + task is not complete
  • If no Complete By date exists, than Past Due flag remains unchecked

So far, I've been able to create a flag based on the first bullet, however-- tasks that do not have a Complete By date associated show as flagged. Would I use an OR in this situation? Not even sure if this is possible-- Any thoughts?


Best Answers

  • @SPark
    @SPark ✭✭✭
    Answer βœ“
    Options

    I've figured it out! I tried to go back and remove my question but it won't let me delete. πŸ€”Here is what I used..

    =IF(ISBLANK([Complete By]@row), 0, IF(AND([Complete By]@row < TODAY(), [Task Complete]@row = 0), 1))

Answers

  • @SPark
    @SPark ✭✭✭
    Answer βœ“
    Options

    I've figured it out! I tried to go back and remove my question but it won't let me delete. πŸ€”Here is what I used..

    =IF(ISBLANK([Complete By]@row), 0, IF(AND([Complete By]@row < TODAY(), [Task Complete]@row = 0), 1))

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!