How do I flag and unflag automatically

KBSheetBI · 01/05/24

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.

=Chris Palmer · 01/05/24

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))

=Chris Palmer · 01/05/24

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))

KBSheetBI · 01/05/24

=Chris Palmer · 01/05/24

Glad this worked for you!

Best Answer