Obtaining information from a Parent
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.
Comments
-
Hi,
Try this.
=PARENT(Quantity@row)
Did it work?
Have a fantastic day!
Best,
Andrée Starå
Workflow Consultant @ Get Done Consulting
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Perfect ! Works wonders !
-
Excellent!
Happy to help!
Best,
Andrée
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:[email protected] | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.