On the same column I need to have
1- a dependent drop down list
2- check for duplicates
1- Property Type[Offer type]
2-
ISBLANK(
FILTER(
"Properties",
AND(
ISNOTBLANK([Province]), ([Province] = [_THISROW].[Province]),
ISNOTBLANK([State]), ([State] = [_THISROW].[State]),
ISNOTBLANK([Village]), ([Village] = [_THISROW].[Village]),
NOT([_ROWNUMBER] = [_THISROW].[_ROWNUMBER])
)
)
)
Can Some Help How to do it
User | Count |
---|---|
18 | |
14 | |
11 | |
7 | |
4 |