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.
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
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
@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.
@ChrisAHeathcote
Shouldn't it be PARENT(ITEM(Child List))?
Misbah
ha!
Yes you are right.
Thank you for your reply!
I got it to use Lookup!! Thank you!!
Thanks for your reply!
I can do it to use 'Lookup' and 'Parent' function!Thank you so much!
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.
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…
Anaplan Champions! The Community team just posted this announcement that certification badges may not be showing up on your profile probably until next year. Rest assured, you will get credit once you complete and pass the exams. https://community.anaplan.com/t5/Blog/Badges-Back-Soon/ba-p/123385
Users may encounter error and warning messages in PlanIQ. The table below includes descriptions of the messages and details what should be done in order to address them, where applicable. Message types: * Errors will fail the relevant PlanIQ step. Users will have to follow the instructions in order to avoid the errors. *…
