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
-
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
-
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.
-
That solved it!
Thank you so much :)
-
Glad you found a solution. Thank you for contributing to the community and for the "insightful".
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!