Multilingual Data Validation

%3CLINGO-SUB%20id%3D%22lingo-sub-1663585%22%20slang%3D%22en-US%22%3EMultilingual%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1663585%22%20slang%3D%22en-US%22%3E%3CP%3EI%20want%20to%20give%20the%20users%20the%20possibility%20to%20work%20in%20their%20local%20language.%3C%2FP%3E%3CP%3EMy%20template%20works%20fine%20for%20this%2C%20except%20for%201%20thing%3A%3C%2FP%3E%3CP%3EThere%20is%20a%20cell%20that%20is%20data%20validated.%20Once%20a%20user%20has%20made%20a%20choice%20in%20his%20local%20language%20and%20the%20file%20is%20saved%20to%20a%20sharepoint%2C%20somebody%20opening%20the%20file%20and%20viewing%20it%20in%20another%20language%2C%20will%20never%20see%20the%20validated%20cell%20content%20in%20his%20selected%20language.%3C%2FP%3E%3CP%3EDid%20somebody%20tried%20and%20succeeded%20%3CLI-EMOJI%20id%3D%22lia_slightly-smiling-face%22%20title%3D%22%3Aslightly_smiling_face%3A%22%3E%3C%2FLI-EMOJI%3E%20this%20before%3F%3C%2FP%3E%3CP%3EI%20was%20thinking%20on%20just%20saving%20a%20number%20and%20then%20lookup%20the%20value%20as%20i%20do%20for%20the%20other%20fields%2C%20but%20still%20at%20the%20moment%20of%20selection%2C%20it%20should%20show%20the%20different%20options%2C%20not%20just%20the%20number%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eany%20suggestion%20is%20welcome%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1663585%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1663602%22%20slang%3D%22en-US%22%3ERe%3A%20Multilingual%20Data%20Validation%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1663602%22%20slang%3D%22en-US%22%3E%3CP%3EPS%3A%20please%20no%20VBA%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I want to give the users the possibility to work in their local language.

My template works fine for this, except for 1 thing:

There is a cell that is data validated. Once a user has made a choice in his local language and the file is saved to a sharepoint, somebody opening the file and viewing it in another language, will never see the validated cell content in his selected language.

Did somebody tried and succeeded this before?

I was thinking on just saving a number and then lookup the value as i do for the other fields, but still at the moment of selection, it should show the different options, not just the number

 

 

any suggestion is welcome

 

  

1 Reply
Highlighted

PS: please no VBA