I need a formula to flag a task

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

  • 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

    Join us for Jumpstart 2025 with Community on 23 January (in two time zones)! 🎉 Register here.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!