How do I flag and unflag automatically

When "start date" is in the past, I need "late start" to flag. If I change the status column to completed or rejected, I need it to unflag

I cannot seem to get any formulas right for this.

Best Answer

  • Mr. Chris
    Mr. Chris ✭✭✭✭✭
    edited 01/05/24 Answer ✓

    Hello @KBSheetBI

    Try this formula inside the Late Start column, and let me know if it works for you:

    =IF(OR(Status@row = "Completed", Status@row = "Rejected"), 0, IF([Start Date]@row > TODAY(), 0, 1))


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!