Value in Field cannot be converted to Type 'Enum'

[Markus_Malessa]

I have the following column set up:

With this ‘Suggested_Values’ formula:

When saving the data, I get a stacked up queue and try to force refresh the data which results in this error:

Hoping someone has a solution for me.

[Steve · Accepted solution]

[Markus_Malessa]

Thanks @Steve. That did the trick. I did not realize that with suggested values it still needed the allowed values list.

[Paras_Sood]

I have made the necessary changes for one of my colleagues this problem still persists. He cannot sync changes in the phone and this problem still shows up.

[Paras_Sood]

Worked after I removed all the pending sync changes. if you face into this issue, all changes have to be reset before you can make it working again.

[Nshockley15]

I’m now having this issue. How did you remove the pending syncs?

[Paras_Sood]

You need to delete those records from whatever device it's not working. 

Maybe this article will help

https://support.google.com/appsheet/answer/10105777?hl=en

[Brice]

Bonjour

J'ai le même problème mais la solution ne fonctionne pas.

Quelqu'un pourrais m'aider?

Merci d'avance

[Lucho_B]

I'm having the same issue, but with only one user.

• Initial value is in the list of allowed values.
• The user has no pending changes; we even deleted all her browsing history and caché.
• When saving a row with the initial value unchanged, she get's the message Value 'xxxx' in field 'yyyy' cannot be converted to type 'Enum' 

Any ideas?
Thank you!