Value in Field cannot be converted to Type 'Enum'

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.

7 Likes

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

2 Likes

Bonjour

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

Quelqu’un pourrais m’aider?

Merci d’avance

1 Like

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.

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.

1 Like

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

1 Like

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

2 Likes

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!