Conditional Dropdown (formula)

Theresa Goodwin

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!

Paul Newcome

I have a few ideas, but could you provide some screenshots so I can figure out which one might be better for you?

Theresa Goodwin

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. 

Paul Newcome

How is the date being selected?

Theresa Goodwin

Date is Column based. Almost like a calendar

Paul Newcome

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?

Theresa Goodwin

Yes! You've got it!