NESTED IF FORMULA WITH PARENT/CHILD ROWS

lisarae723
lisarae723 ✭✭✭✭✭
edited 12/09/19 in Formulas and Functions

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

 

On Track - Off Track.png

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!