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!
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.9K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives