Head back to the MainGoogle Sheet tab Give A1 the header Option 1. Click to Expand! Set up the first dropdown data validation In cell A1, add the header Option 1 and column B1 the header Option 2. Then from column A2 down type in three sets of each of the following:įinally, from B2 down type in the corresponding number followed by A, B and then C for each number set so that it looks like this. Go ahead and create a new Google Sheet tab and call it Notes. Setting up the dropdown data for Columns A & B Update column B in Maindrop-down data validation and change their relative and absolute values.Reference Column A, Mainand recreate individual selections for each row that we will hide in Notes.Set up our Column A dropdown back in Main.Add a list of all the selected items in Column A and Column B.To achieve this dynamic dropdown in column B we need to do a number of steps: So how did we achieve this? Well, just like in the original tutorial we relied on another Google Sheet tab that, in this example, I have labelled, Notes. So our range might look like this: Click to Expand! The solution So the user can select a value in any row in column A and that will update the corresponding Google Sheets data-validation options in column B. We also want the same scenario to occur for each row. However, if the user selects ‘two’ in cell A2, then B2will have a different set of values such as: If the user selects ‘one’ in say cell A2, then cell B2will have a corresponding set of values that we will make: We’ll keep it simple and make our options: Let’s say in column A of our Google Sheet tab called Main, we want a dropdown menu for each cell in your column from, say A2:A12. Working our the remaining options for each row.
0 kommentar(er)
