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.

### Like this:

Like Loading...

*Related*

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