Hello Community.


I have two substasks in a task.

At subtask level, I would like to assess information from the task. You can consider the enclosed screenshot.

Please consider the cell highlighted in light yellow. For this cell, I would like to access the quantity from the first line.


INDEX(PARENT(),1) does not seem to work. Neither does  INDEX(PARENT(),0) works.




Try this.

=PARENT([email protected])

Did it work?

Have a fantastic day!


Andrée Starå

Workflow Consultant @ Get Done Consulting

Perfect ! Works wonders !