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.



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!