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.
-
How is the date being 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
- 64.9K Get Help
- 441 Global Discussions
- 139 Industry Talk
- 471 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 68 Community Job Board
- 496 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives