Red flag on/off control to indicate project RISK

Abiola

Hi All,

I have a column named 'risk' and the flag only toggled on when certain conditions are met- uncompleted activities that exceeded 30 days after the planned end date;

=IF(Status@row = "Cancelled", 0, IF(AND([End Date]@row < TODAY(30), Status@row <> "Completed"), 1, 0))

It works pretty well but, I would like it not to toggled on rows that do not have start and end date (header rows)

Thanks

Abiola

Andrée Starå

Hi @Abiola

I hope you're well and safe!

Try something like this.

=IF(OR([Start Date]@row = "", [End Date]@row = ""), "", 
IF(Status@row = "Cancelled", 0, IF(AND([End Date]@row < TODAY(30), 
Status@row <> "Completed"), 1, 0)))

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Abiola

Hi @Andrée Starå

Works like magic. Super thanks!

Abiola

Andrée Starå

Hi @Abiola

I hope you're well and safe!

Try something like this.

=IF(OR([Start Date]@row = "", [End Date]@row = ""), "", 
IF(Status@row = "Cancelled", 0, IF(AND([End Date]@row < TODAY(30), 
Status@row <> "Completed"), 1, 0)))

Did that work/help?

I hope that helps!

Be safe and have a fantastic day!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Abiola

Hi @Andrée Starå

Works like magic. Super thanks!

Abiola

Andrée Starå

@Abiola

Excellent!

You're more than welcome!