I need a formula to flag a task

Options

I need help with a formula.

I want to use this formula for the Due Date but I need to modify it so I can add in criteria if the Start Date has been passed & the task Status shows either Delayed or Not Started

=IF([Due Date]@row = "", "", IF(AND(OR(Status@row = "Not Started", Status@row = "Assigned", Status@row = "Scheduled", Status@row = "In Progress"), [Due Date]@row <= TODAY(-2)), 1, 0)

Thanks

Answers

  • Genevieve P.
    Genevieve P. Employee Admin
    Options

    Hi @Christine Adams

    I presume you want "1" to appear (or the flag to be checked) with the additional criteria, is that correct?

    If so, we can add these statements into your AND function within another OR, like so:

    =IF([Due Date]@row = "", "", IF(OR(AND(OR(Status@row = "Not Started", Status@row = "Assigned", Status@row = "Scheduled", Status@row = "In Progress"), [Due Date]@row <= TODAY(-2)), AND(OR(Status@row = "Delayed", Status@row = "Not Started"), [Start Date]@row > TODAY())), 1, 0)

    Cheers,

    Genevieve

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!