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.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-year…
Has anyone found success using Anaplan XL with Polaris models in a shared drive with or without concurrent users? My team has experienced a variety of errors, login failures, etc. sometimes it works, sometimes it doesn't. We've been recommended to save and edit files locally, which helps but certainly with its limitations…
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.…
