This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

Enumlist - Show column A in dropdown but log column B in sheet

Posted on 09-02-2022 06:02 AM
Jens_Damen1
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

I'm using an enumlist in the way described here :

https://www.googlecloudcommunity.com/gc/Tips-Tricks/Many-to-Many-Relationships/m-p/261816

But I want to edit this so the dropdown will show column [Model] but in the sheet it will log the value from column [ID] from that same row.

Can't seem to figure out how to make this work.

I have this valid if formula in my enumlist with ref type: Table1[Model]

Solved Solved
0 4 115
Topic Labels
Jump to Solution
0 Likes
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
Jens_Damen1
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

So I accidentally stumbled upon the solution myself.

I had my ID column both as KEY and as LABEL. But changing the LABEL from my ID column to my MODEL column gave me the result I wanted.
Model value is shown in the dropdown and the ID value is logged in the sheet.

View solution in original post

Jump to Solution
4 REPLIES 4
Top Labels in this Space