Creating a sub-location

I need to create sub-locations within the main building, how can i set that the sub-location is able to be chosen related to the main location?

for example: a building A with store 1, 2, 3, and building B with store 4, 5, 6, if the main location is set to building A, then only store 1, 2, 3 is available for chosing.

if there is such level feature, how many level is supported?

Thanks in advance


If the sub-location is select from other sheet (like link and load), you could try Dynamic-Filtering.
If it’s selection field, Cascasded-Selections might be the solution.

hi, thanks for your help, from the example i think cascaded selections would be more suitable.

i should try it out, thanks again. :blush:

1 Like