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
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 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!