How do I automatically un-flag?

KBSheetBI

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?

John_Foster

Hi @KBSheetBI,

Try this formula.

=IF([Status]@row = "Completed",0,IF(AND(ISBLANK([Start Date]@row), [Planned Start Date]@row < TODAY()), 1, 0))

Hope this helps!

John

John_Foster

Hi @KBSheetBI,

You are welcome. For the rejected you can use the below, there may be a better way but this is what I would use.

=IF([Status]@row = "Rejected",0,IF([Status]@row = "Completed",0,IF(AND(ISBLANK([Start Date]@row), [Planned Start Date]@row < TODAY()), 1, 0)))

John

John_Foster

Hi @KBSheetBI,

Try this formula.

=IF([Status]@row = "Completed",0,IF(AND(ISBLANK([Start Date]@row), [Planned Start Date]@row < TODAY()), 1, 0))

Hope this helps!

John

KBSheetBI

Thank you, Sir!!

KBSheetBI

@John_Foster This works great! What do I need to add to the formula when status is rejected? would want it to remove the flag just like it does when completed

John_Foster

Hi @KBSheetBI,

You are welcome. For the rejected you can use the below, there may be a better way but this is what I would use.

=IF([Status]@row = "Rejected",0,IF([Status]@row = "Completed",0,IF(AND(ISBLANK([Start Date]@row), [Planned Start Date]@row < TODAY()), 1, 0)))

John

KBSheetBI

@John_Foster it works. You are the man!