NESTED IF FORMULA WITH PARENT/CHILD ROWS

lisarae723

Hi everyone,

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"))

 

Paul Newcome

Remove the quotes from around your criteria. When you use quotes, SS looks for that EXACT text, but you are referencing percentages. Also... 98% is actually .98 instead of .098. See if that helps any.

lisarae723

Hello Paul,

Thank you so much for your feedback.  It's so nice to have help so readily available when your stuck on a problem.

Paul Newcome

Happy to help.