I try to figure out how i remove duplicate values from a list i use in a form that take part of validation dropdown: I have
a sheet containinh income\expence definitions:
uniqueID | Sub-sub-definition | Sub Definition | Definition
Definition is :
Income or Expence Sub Defs: list of about 30 rows. Sub-Sub Defs: is about 120 definitions.
The problem is after choosing Definition, Sub Definition Shows me duplicate values (because related to Sub-Sub-Definition).
Im not even sure this worksheet structure is good for appsheet use…
attaching a screenshot.
Any ideas how to make the Sub Def show only unique values?