Changes to entries made through validation

[Jake]

I have users select items from a validation list that dynamically displays
the list items in the language of the user's choice and then enters that item
in the language selected. The problem is if another user changes the
language for the spreadsheet, the entry made through the validation list
remains in the original language. I've used two columns, one for the
validation and another to allow the language to change for that entry. This
is a bit awkward though. I've looked at the posts and the Contextures page,
but not seen any similar difficulties.
Thanks for any help
Jake

 

[Mike H.]

When a user changes the language, why not have a macro run at that moment
that goes through all the data in the sheet and updates the language
displayed. Or store the actual response in, say, English and have that
column hidden and then have the display column do a lookup to the your
language conversion table to convert your hidden English word and display the
resulting language's word. Not sure this will help, but since it has been a
couple days with no other responses, I thought I'd give it a try.