How do I automatically un-flag?

If planned start is in the past and start date is blank. Late start populates a red flag a red flag.

This is the formula: =IF(AND(ISBLANK([Start Date]@row), [Planned Start Date]@row < TODAY()), 1, 0)

When a cell says "completed" in the status column, how do I get it to unflag?

Best Answers


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!