This discussion reminded me that not only is my job board a planning and organizational tool, but it is also a powerful communication tool! The ability to translate adds so much to golf maintenance crews that are more diverse than my crew (we all speak english).
|Spanish anyone? how about Chinese?|
For those of you who use my job board I will share the formula that gives the job board the ability to translate for you. Just paste this formula into cells C4:F8. You will also need to add a column to the right of the employee names in the "lists" sheet. This will be where you put the language codes for each employee into. "en" for English, "es"for Spanish. A full list of the language codes can be found here. Just use the 2 letter code in column 2. Now all you have to do is add tasks to the planner and voila, they appear in the desired language on the job board!
I have set the input language to "Auto." What this does is use the system language settings as the input language. I highly encourage people to check out my formulas and learn how they work. Google has a great function help section that you can use to reverse engineer the formulas I use in my sheets.
|add a colum to the right of the employee names|
If you have a multi-lingual crew I highly recommend checking out the =googletranslate function in Google Sheets. This adds a powerful tool that most of the paid software job boards can't offer and best of all it's free!