Obtaining information from a Parent

tfassnacht

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.

 

Andrée Starå

Hi,

Try this.

=PARENT(Quantity@row)

Did it work?

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

tfassnacht

Perfect ! Works wonders !

 

Andrée Starå

Excellent!

Happy to help!

Best,

Andrée