Forum Discussion

phdgolf's avatar
phdgolf
Copper Contributor
Apr 11, 2023

Default value for drop down list from a different cell in the same row

Good day, I have created a drop down list that has 3 choices but would like to have a default value set based on the contents of another cell in the same row.  The contents of the other cell match 1...
  • phdgolf's avatar
    Apr 11, 2023
    Success. Problem solved. I found out I could just reference the default value in the cell and it does not overlay the drop down list (Cell H5 with drop down list added "=I5"). The drop down list still functions as it should.
    Hope everyone has a great week.
    Best wishes,
    phdgolf

Resources