Selecting value from column based on dropdown selection


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.

Best Answer

  • hollyconradsmith
    hollyconradsmith ✭✭✭✭
    Answer ✓

    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 ?

    Holly Conrad Smith

    Director of Technology & Innovation 💡 at Streamline

    CliftonStrengths Top 5: Deliberative, Restorative, Achiever, Consistency, Harmony


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!