Two Conditional Statements in a valid_if

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

0 5 83
5 REPLIES 5
Top Labels in this Space