Overdue / Due <10 days

We are flagging items overdue as well as less than 10 days. The issue is when an item is past due we only want the flag on for Overdue not Due < 10 days so that reporting is appropriate. What I would like to do is check to see if overdue flag is set and not set the Due < 10 days.


=IF(AND([Over Due]@row = "FALSE") = IF(AND([% Complete]@row < 1, [Trending End Date]@row - TODAY() <= 10), 1, 0))

Answers

  • Genevieve P.
    Genevieve P. Employee Admin

    Hi Kristopher,

    You can have all these statements in the same AND function. Try this:

    =IF(AND([Over Due]@row = "False", [% Complete]@row < 1, [Trending End Date]@row - TODAY() <= 10), 1, 0)


    Now all three of those criteria need to be met before this column will have a flag. If the Over Due column is not false (meaning there's a flag in that column), this one won't be flagged. Is that what you wanted? If I've misunderstood, it may be helpful to see a screen capture of your sheet (but please block out any sensitive data).

    Thanks!

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!