Re: Dropdown List not generating?

MikeM · 01-03-2020 01:35 AM

Hello,

I’ve imported my Google Sheet, set one column as ‘enum’ and provided a list of values, however, it is still showing as a number within the app, not as a drop-down menu. It should show a list of reason codes from 1 - 5, however it just shows ‘1’ as a static element. How do I fix this?

How it currently looks, what I expect and my column setup can be found here:

[Album] Imgur ...

Thanks

Aleksi

What formula are you using with the Valid If or do you have fixed values?

MikeM

I have fixed values

Aleksi

Do you have any initial value?

MikeM

Yes, it’s set as =“Reason Code 1”

Steve

Please post a full screenshot of the view that displays the reason code improperly.

MikeM

I’ve had to blank out the picture up the top due to GDPR

Steve

Your screenshot appears to show what I understand is your desired behavior. Do I misunderstand?

MikeM

I was expecting a dropdown box to allow a user to select an option, from the values I’ve set

Steve

The view in your screenshot appears to be a detail view. Normally, users cannot modify values directly from the detail view. If you want that column value modifiable from the detail view, you’ll need mark it for Quick Edit.

MikeM

Fantastic - Thank you! It wasn’t too clear in the drop-down article on your help center but this has solved it.