Hi,
So here's my problem. In cell A1 I want to select either Yes or No using a dropdown.
In cell B1 I want to have another option
If I select Yes, I want my dropdown in B1 to automatically select Always, but to have a second dropdown option of Sometimes
If I select No in A1, I want there to only be one entry in B1, Never, and I want this to change automatically if I select No
Bookmarks