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