Flag at Risk column based on child rows summary
sahilhq
✭✭✭✭✭✭
I have an "At Risk" column where the flag is triggered when a certain condition is met. Can anyone please suggest with a formula for each parent row in the at risk column such that if the child rows have more flags raised than blanks then the parent row cell needs to also be flagged up? So say if there are 6 child rows for a task and 4 out of the 6 tasks have been flagged up, then the parent row cell needs to be also flagged. Also, even if 3 out of the 6 child rows have flags raised I would prefer the parent row cell to be flagged up.
Tags:
Answers
-
=IF(COUNT(CHILDREN()) >= 0.5 * COUNTIF(CHILDREN(), OR(ISBLANK(@cell), @cell = 1)), 1, 0)
This will flag it if 50% or more of the children are flagged.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!