locked
Formula syntax in French RRS feed

  • Question

  • Hi,

    I've created a subsite whereby the language is in French. After creating a list where one of the columns is a "Calculated (calculation based on other columns)", I cannot seem to complete it. After entering the formula, I always get this error:

    "La formule contient une erreur de syntaxe ou n'est pas prise en charge. "

    So am I to assume that the syntax used has to be in French as well? If so, where can I find a list of those syntax?

    Wednesday, January 8, 2014 2:24 PM

All replies

  • Try entering the formula into Excel first.  If the formula works in Excel, it will work in SharePoint.

    I trust that answers your question...

    Thanks
    C

    | RSS | http://crayveon.com/blog | SharePoint Scripts | Twitter | Google+ | LinkedIn | Facebook | Quix Utilities for SharePoint

    Wednesday, January 8, 2014 3:12 PM
    Answerer
  • Thanks.

    I tried doing this but I'm still getting the error. Any comments is appreciated.

    =SI([Completed Date]="","",SI(AND((JOURSEM([Date de fin],2))<(JOURSEM([Créé],2)),((JOURSEM([Créé],2))-(JOURSEM([Date de fin],2)))>1),(((DATEDIF([Créé],[Date de fin],"D")+1))-(PLANCHER(DATEDIF([Créé],[Date de fin],"D")+1)/7,1)*2)-2),(((DATEDIF([Créé],[Date de fin],"D")+1))-(PLANCHER((DATEDIF([Créé],[Date de fin],"D")+1)/7,1)*2))))

    Wednesday, January 8, 2014 4:52 PM