hi!When I check list items in the parent hierarchy, I want to create a mechanism to check all items in the child hierarchy.
What i should do?
Please help me.
Go to Solution.
Hi @KubotaNatsuki ,
In your query, assuming 'Check' = assigning ✅ to a list item in parent list, you can Lookup the parent property (which @ChrisHeathcote explained) to apply it to child items pertaining to that parent.
View solution in original post
You'll need to provide more information.
I find that a working sample on Excel that you attach here normally helps.
Create a module dimensioned by the child list.
Add a list formatted line item containing the parent list.
Use; ITEM(PARENT('Child List')) to pull through the parent of the list item.
Now you can see the parent of each child list item in a single location. If a child list item does not have a parent then the result will be blank.
Shouldn't it be PARENT(ITEM(Child List))?
Yes you are right.
Thanks for your reply!
I can do it to use 'Lookup' and 'Parent' function!Thank you so much!
Thank you for your reply!
I got it to use Lookup!! Thank you!!
While using LOOKUP will return the parent list item as per a mapping module dimensioned by the child item but the formula will not be as efficient as using PARENT.