NESTED IF FORMULA WITH PARENT/CHILD ROWS
I am struggling with a formula to populate a parent row, as either "On Track" or "Off Track". This is dependent on how the child row compares to the "Weekly Goal". The formula I am trying to use is shown below but, Im doing something wrong. (screen shot of sheet also attached)
=(IF(CHILDREN([January (Week 1)]@row => "0.098", "On Track"))
Help Article Resources
Check out the Formula Handbook template!