Selecting value from column based on dropdown selection

Chris Carter

Hi,

I have a planning sheet with several benchmark date columns. I have a single selection drop down column called Current Benchmark with each of the benchmark date columns included in the selection list. I am trying to create a formula so based on the drop down selected in Current Benchmark, the date of that benchmark will be pulled from the corresponding column. I want this so I can pull it into a report and post it on a Dashboard without needing to list every benchmark date. Any suggestions would be greatly appreciated.

hollyconradsmith

Hi @Chris Carter ,

Are you able to provide a screenshot of the column names?

I am thinking something like this nested if formula could work though:

=if([current benchmark]@row="benchmark dropdown 1", benchmark1@row, if([current benchmark]@row="benchmark dropdown 2", benchmark2@row... etc ?

hollyconradsmith

Hi @Chris Carter ,

Are you able to provide a screenshot of the column names?

I am thinking something like this nested if formula could work though:

=if([current benchmark]@row="benchmark dropdown 1", benchmark1@row, if([current benchmark]@row="benchmark dropdown 2", benchmark2@row... etc ?

Chris Carter

There are too many columns to include in a single screen shot. I tried that formula just with one column to begin with but got the error "#INVALID COLUMN VALUE"

Thanks

Chris Carter

Sorry, my formula column has to be a date column type. I should have known that.

Chris Carter

It works for one but when I add additional it says Unparseable.