Hi.
Please, help me. I want create a validation list on column ‘Account’ (P) that should appear a valid one to the Date (H) only account (B) that is not closed (column E in blank) or that the Date (H) is in period between Start (C) and End (D).
In this way, in Account (P) for the ‘TransacID’ 1 must appear only “Visa2” and “bank2”; for ‘TransacID’ 2 should appear “Visa2”, “bank2” and “cash2” because Date (H) of this transact is in period of this account; for ‘TransacID’ 3 should appear “Visa2”, “bank2” and “cash3” because Date (H) of this transact is in period of this account. Find file attached.
ConditionalValidation.ods (20.5 KB)