Conditional Dropdown (formula)
I am trying to get dropdown options to change based on data entered in previously in the row.
I have the formula I need to pull the information in earlier in the row but at the end of the sheet, I have columns with dates and need the option to pull that value over to only the cells that are selected. This seemed like a drop down would be best, but I am open to anything.
Example: Column 3 has the option of being A-G and pulls in the correct letter with a formula based on another sheet.
Columns 4-28 are all dated where I need the letter (A-G) that was populate via formula in column 3 to be put into only the ones I select. therefore column 5,7,8, and 10 need to have "B" in them while the rest of the columns in this row remain blank/unselected
Name Category Letter Date 1 Date 2 Date 3 Date 4 Date 5 Date 6 Date7 -->
test Project B B B B B
test2 Project G G G
Is this possible?
Thanks!
Comments
-
I have a few ideas, but could you provide some screenshots so I can figure out which one might be better for you?
-
The two white columns were me testing.
This shows the formula populated "Short" column.
Then the date columns where i need the Short text to be populated only when the date is selected.
-
-
Date is Column based. Almost like a calendar
-
So to make sure I am clear on this (I'm just using examples here. Details can be adjusted once the framework is set.)...
If Short says "EBSD", then you want "EBSD" to be populated in a group of predetermined columns that will remain the same regardless of row. So for example,
Short = EBSD so EBSD is populated in 12/17/19, 12/31/19, and 1/21/19
Short = EWD so EWD is populated in 12/24/19 and 1/28/19
Is that correct?
-
Yes! You've got it!
