At risk flag turns on if any flag under its hierarchy is flagged

Gregory Zalecki

I have a formula set to trigger an at risk flag if a column in the row is blank. How do I write a formula for the main row (Hierarchy = 0) to trigger if any at risk flag in that section is triggered?

Mark Cronk

Try:

=IF(hierarchy@row=0, IF(countifs(children([risk]@row), @cell =1)>0, 1, 0))

Change the column names if my guesses are incorrect.

Work?

Mark

Mark Cronk

Try:

=IF(hierarchy@row=0, IF(countifs(children([risk]@row), @cell =1)>0, 1, 0))

Change the column names if my guesses are incorrect.

Work?

Mark

Gregory Zalecki

That solved it!

Thank you so much :)

Mark Cronk

Glad you found a solution. Thank you for contributing to the community and for the "insightful".

Mark