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.
Hi, I have a module with a time range as a dimension. I've set it with a daily time scale, but Anaplan's way of showing daily dates is for example "1 Jan 37" and I need it to be in numbers because when I export it excel doesn't recognize it as the date format that I've set in Windows (OS) (when a date as two digits it's…
Hello, My interface uses basic authentication to log in to Anaplan. The login process has been failing intermittently for about a week. How can I identify the root cause of these Anaplan API login failures? Username and password are correct. The account is not locked or expired. Thanks, Jorge Palma
Hello Anaplan Community, I'm facing an issue while uploading ADO screenshots, crosschecked my file size and naming conventions they are correct as mentioned in the lesson. Anyone faced the same issue? Pls let me know how if any solution to this problem. Thank you.
