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
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
I made virtual column "include" like below. App formula is
select(Sheet1[Place], in([_thisrow].[Place], [within]))
I could get "California" in "United States". But I also want to take grand child "Los Angeles". Is it possible ?
Solved! Go to 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?
User | Count |
---|---|
17 | |
11 | |
7 | |
3 | |
2 |