I have 2 sheets
- Sheet 1 houses the records for 2 of my dropdowns (enum with valid if selection to that sheet)
- Sheet 2 will save all data belonging to records (2 columns are the dropdown above)
Now I already figured out that I can use suggested values instead of valid if to allow new entries.
But this will only add this value in sheet 2 and will not add it to my sheet 1.
I’d like to create the option to make the dropdown grow by user input.
So when a user uses the add option it will get added to the record list in sheet 2 but the list for the enum will also get the new record.
How could I achieve this?