If/Then formula for symbols based on range?


I'm collecting responses from multiple departments for the same question. I've added the question to a parent row, and each department is a child row below it. Status is a ball symbol...red=issue, yellow=in progress, and green=complete...and every row has a symbol.

I'd like to create a formula on the parent row based on the child rows. So, if any child row has a red ball, the parent row will have a red ball. If child rows have no red but at least one yellow, the parent row will have a yellow status. And finally, the parent row will only show green status if ALL child rows are green.

I'm not sure where to even start with this formula! Any help is appreciated :)

Thank you!

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!