I want to populate a dropdown list based on a selection of another cell's dropdown list.
E.g., if the user does not make a choice from D20 dropdown menu, therefore F20 dropdown is Blank but has the option of only ChoiceA in its dropdown menu.
If User does make a choice from the D20 drop-menu, therefore F20 is Blank but has options of ChoiceA, ChoiceB, and ChoiceC in its dropdown menu.
I've played around with the below but it's not quite right...
This formula is in cell Sheet2!B:14
and my Sheet1!F20 cell uses data validation list from range Sheet2!B14:B16
On a single line it works as needed, but when rows are added issue that arose is once a selection is made anywhere in column D that allows for all 3 choices in the F column drop-menu, then all 3 choices become permanently available in any added F column cells regardless of column D choice in the same row.
Another issue needing a fix is if the option in Column D is deleted, all three options are also still available - although a warning comment is present.
Can these issues be solved either with formula or script?