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.
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…
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.…