hierarchy list and child list

KubotaNatsuki
KubotaNatsuki
in Modeling

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.

 

Tagged:

Best Answer

  • Vinay VaradarajM
    Vinay VaradarajM
    Answer ✓

    Hi @KubotaNatsuki ,

     

    In your query, assuming 'Check' = assigning ✅ to a list item in parent list, you can Lookup the parent property (which @ChrisAHeathcote explained) to apply it to child items pertaining to that parent.

     

    Regards,

    vinayvm

Answers

  • LipChean_Soh
    LipChean_Soh

    Hi @KubotaNatsuki 

     

    You'll need to provide more information.

    I find that a working sample on Excel that you attach here normally helps.

     

    Thanks,

    LipChean

  • ChrisAHeathcote
    ChrisAHeathcote

    @KubotaNatsuki 

    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.

  • Misbah
    Misbah

    @ChrisAHeathcote 

     

    Shouldn't it be PARENT(ITEM(Child List))?

     

    Misbah

  • ChrisAHeathcote
    ChrisAHeathcote

    ha!

    Yes you are right.

     

  • KubotaNatsuki
    KubotaNatsuki

    Thank you for your reply!

    I got it to use Lookup!! 
    Thank you!!

  • KubotaNatsuki
    KubotaNatsuki

    Thanks for your reply!

    I can do it to use 'Lookup' and 'Parent' function!
    Thank you so much!

  • ChrisAHeathcote
    ChrisAHeathcote

    @KubotaNatsuki 

    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. 

     

Categories