Averaging RGB balls
I'm hoping this is quite simple, but my simple mind is struggling to piece it together.
I have a Parent Row with multiple Children but only one hierarchy below it and i want the parent row to average the status of the Red, Green and Blue balls on the Children rows...make sense?
Help would be much appreciated, screen shot below:
Help Article Resources
Check out the Formula Handbook template!