At Risk Flag Formula

mmac · 08/09/19

Hello,

I have a number of "parent rows" with children indented just underneath. Each parent row contains a keyword "launch". I'm hoping someone may be able to assist in a formula.

What I am looking for in theory, if any children indented rows are flagged at risk, the formula would then flag at risk for the parent row. Hopefully I'm making sense here.

3MrQg6VQRMPPmq8wJHMJc2VP6fJhhRpcvqjP6Jc1-2019-08-09_5_58.png

djpreece · 08/09/19

Pretty sure this will work

Add a column to the left of the At Risk column…[New Column]

Parent =if(Sum(children()) > 0,1,0)

Children = if([At Risk]@row,1,0)

Parent [At Risk] cell =if([New Column]@row = 1,1,0)

-dp-

Andrée Starå · 08/10/19

Hi,

Try something like this.

Add the following formula to the At Risk column on parent rows.

=IF(COUNTIF(CHILDREN(); 1) > 0; 1)

The same version but with the below changes for your and others convenience.

=IF(COUNTIF(CHILDREN(), 1) > 0, 1)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

At Risk Flag Formula

Comments

Help Article Resources

Categories