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

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?

Best Answer

  • Mark Cronk
    Mark Cronk ✭✭✭✭✭✭
    Answer ✓

    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


    I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!