Hello I want to create dropdown showing only years! How ?
The easiest way is to write them manually, like:
If you want to generate them dynamically based in a list/search, you can do this:
In the example above, I created a list of the years of my users creation date. First I formatted the data as text (yyyy) and after I picked only UNIQUE ELEMENTS to prevent duplicates years…
Here is an idea depending the requirement
Dropdown showing list of years using the Toolbox 'list of numbers'?
Note: you cannot see the actual dropdown choices unfortunately on the screen recording
Aww, Thanks for your video , I really appreciate