Displaying a Dropdown list based on Yes/No entry in another cell
13 views
Skip to first unread message
Mike Sindona
Feb 24, 2025, 5:03:48 PMFeb 24
to Google Sheets Community
Hello.
I have two cells in Sheet1: A1 and B1. In the A1 cell is a simple "Yes/No" dropdown. If this A1 dropdown remains untouched, or if the user selects "No", then nothing should happen in the B1 cell. It remains empty.
But if the user selects "Yes" in the A1 dropdown, then I want the B1 cell to be populated with another dropdown that pulls data from a single column (A1:A) in Sheet2.
I have two cells in Sheet1: A1 and B1. In the A1 cell is a simple "Yes/No" dropdown. If this A1 dropdown remains untouched, or if the user selects "No", then nothing should happen in the B1 cell. It remains empty.
But if the user selects "Yes" in the A1 dropdown, then I want the B1 cell to be populated with another dropdown that pulls data from a single column (A1:A) in Sheet2.
I know how to pull the data over from Sheet2 into the Sheet1 B2 dropdown, I just don't want the Sheet1 B1 dropdown to be displayed unless the user selects "Yes" in the Sheet1 A1 dropdown.
Is this possible? Seems simple, but I just can't figure out how to get it done.
IF A1 = "Yes", THEN (Display dropdown in B1), ELSE (Do nothing)
Thanks - Mike
Is this possible? Seems simple, but I just can't figure out how to get it done.
IF A1 = "Yes", THEN (Display dropdown in B1), ELSE (Do nothing)
Thanks - Mike
Valmir
Mar 20, 2025, 8:49:44 AMMar 20
to Google Sheets Community
see this sheet 👇
Reply all
Reply to author
Forward
0 new messages