Get all child and grand child task by Ref_row

Usually task and project has several hierarchy. Appsheet can take child task by Ref_row, but is it possible to take all child and grand child task?

For example, I have sheet like below

amufaamo_0-1654761673548.png

For example, United States includes California, and California includes Los Angeles. 

It means United States includes California and Los Angeles, so I want to take both California and Los Angeles by list.

Within is Enumlist, which can choose places

amufaamo_1-1654761734734.png

I made virtual column "include" like below. App formula is 

select(Sheet1[Place], in([_thisrow].[Place], [within]))

amufaamo_2-1654761886400.png

I could get "California" in "United States". But I also want to take grand child "Los Angeles". Is it possible ?

amufaamo_3-1654761993887.png

 

Solved Solved
0 3 117
1 ACCEPTED SOLUTION

Yes.  But may I suggestion you talk with an Appsheet Dev like myself or one of the others so that you get your data structure right first time?

 

View solution in original post

3 REPLIES 3
Top Labels in this Space