IF Formula with Children
I am new to Smartsheet so apologies if this has been answered elsewhere.
I am trying to change RYG balls for a parent row based on children rows being marked done or not. I've used this formula which seems to work, but it gets tedious when there are several Child rows to include or if I want to add another Child row. Is there an easier way with the CHILD or PARENT functions?
=IF(AND(Completed3 = 1, Completed4 = 1, Completed5 = 1, Completed6 = 1), "Green", IF(OR(Completed3 = 1, Completed4 = 1, Completed5 = 1, Completed6 = 1), "Yellow", "Red"))
Help Article Resources
Check out the Formula Handbook template!