Color coding: help me translate the formula!

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.

Advertisements

10 thoughts on “Color coding: help me translate the formula!

  1. 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

  2. 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

  3. Thank you for your great work!

    Here is the formula, using [Status] field, in Italian language (, –> ;):

    =” “&[Titolo]&””

  4. 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

  5. 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

  6. 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

Comments are closed.