I recently published a new version of my formula generator for color coding calendars and lists:
http://www.pathtosharepoint.com/sharepoint-user-toolkit/Pages/Color-Coding-Calendar-List.aspx
I wrote the formula for the English version of SharePoint. I’d like to offer other languages, but for this I need to know how to translate the following functions:
IF function: IF([Column name]=”string”,Yes,No)
Concatenate symbol: &
Update [April 5]: I’d also be interested in the translation of the CHOOSE, LEFT and RIGHT functions for another formula generator.
If you have a non-English version of SharePoint and know the answer, I’d appreciate if you could leave a comment telling me the language you’re using and the localized equivalents of the English functions.
Thanks for your help!
Note: the color names remain in English, as these are actually color codes recognized by the browsers.
Path to SharePoint... and Beyond! 
Dutch:
=ALS(Titel=”Test”;”Ja”;”Nee”)&” MijnWaarde”
If [Titel] is equal to “Test” then “Ja” Else “Nee” and append ” MijnWaarde”
Mind that the , is change to a ; in the ALS-formula.
And yes i hate it too that SharePoint doesn’t give meaning full errors on the Calculated Column
Most of the function names are the same in excel ( i suspect the same ‘engine’ under the hood) So you can you this list as a starter:
http://dolf.trieschnigg.nl/excel/excel.html
Here is an example of a translated color coding to french.
=SI(État=”Non commencé”;”Gainsboro”; SI(État=”En cours”;SI(Priorité=”(1) haute”;”red”; SI(Priorité=”(2) Normale”;”yellow”;SI(Priorité=”(3) Faible”;”green”;”ADFF2F”))); SI(État=”Différé”;”Thistle”;SI(État=”Terminé”;”skyblue”;”Black”))))
Serge Tremblay
SharePoint Server MVP
Thank you for your great work!
Here is the formula, using [Status] field, in Italian language (, –> ;):
=” “&[Titolo]&””
Thanks! The form now includes formulas in Dutch and French. Patrizia, I sent you an e-mail as my blog ate your comment.
Christophe, I have not received your email (I changed my email address in this comment).
I hope this comment is correct and visible.
IF function:
SE(Stato="";"Black";SE(Stato="Non Iniziata";"Magenta";SE(Stato="In Corso";"Darkorange";SE(Stato="Completata";"Green";SE(Stato="Rinviata";"Maroon";"")))))
Concatenate symbol: &
CHOOSE: SCEGLI
LEFT: SINISTRA
RIGHT: DESTRA
Thank you
Patrizia
Thanks Patrizia! I have added Italian to the languages drop-down list.
Great – many thanks Christophe!
Here is finnish translation
IF function:
=JOS([Tila]=””;”Black”;JOS([Tila]=”Aloittamatta”;”Red”;JOS([Tila]=”Käynnissä”;”Gold”;JOS([Tila]=”Valmis”;”Green”;JOS([Tila]=”Lykätty”;”DarkBlue”;JOS([Tila]=”Odottaa tietoja toiselta käyttäjältä”;”DarkCyan”;””))))))
Concatenate symbol: &
CHOOSE: VALITSE.INDEKSI
LEFT: VASEN
RIGHT: OIKEA
German:
=IF([Status]=””;”Black”;IF([Status]=”Nicht begonnen”;”Red”;IF([Status]=” In Bearbeitung”;”Gold”;IF([Status]=”Abgeschlossen”;”Green”;IF([Status]=”Zurückgestellt”;”DarkBlue”;IF([Status]=”Wartet auf jemand anderen”;”DarkCyan”;””))))))
CHOOSE: WAHL
LEFT: LINKS
RIGHT: RECHTS
Cheers,
Manuel