How do I un-flag automatically?

I am wondering how to unflag in my sheet automatically

I need it to flag when start date and/or finish date is in the past and status is not "completed"

I then also need it to un-flag when the status column is changed to completed or rejected

Anyone know of a formula?


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!