calculated site columns cannot be added to lists due to formulas localized to non-eglish language

%3CLINGO-SUB%20id%3D%22lingo-sub-2511507%22%20slang%3D%22en-US%22%3Ecalculated%20site%20columns%20cannot%20be%20added%20to%20lists%20due%20to%20formulas%20localized%20to%20non-eglish%20language%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2511507%22%20slang%3D%22en-US%22%3E%3CP%3EWe've%20a%20Pt-Br%20tenant.%20All%20Excel%20functions%20are%20(unfortunately)%20localized.%20If%20one%20creates%20a%20site%20column%20whose%20formula%20uses%20such%20localized%20functions%2C%20it%20cannot%20be%20added%20to%20lists.%20This%20is%20a%20BIG%20issue%20that%20has%20stayed%20for%20yet%20a%20very%20long%20time.%20Any%20update%20on%20if%20this%20problem%20will%20be%20ever%20fixed%20by%20some%20means%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAn%20example%3A%20say%20you%20create%20a%20calculated%2C%20single%20text%20line%20site%20column%20%22X%22%20where%20its%20formula%20is%20like%20this%20(see%20that%20we%20are%20FORCED%20by%20SPO%20to%20use%20localized%20function%20names%20otherwise%20it%20will%20return%20an%20error%20message%20about%20wrong%20syntax)%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22msauaf_0-1625246114784.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293145i276E1ED5A65F780F%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22msauaf_0-1625246114784.png%22%20alt%3D%22msauaf_0-1625246114784.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETHEN%20you%20go%20back%20to%20EDIT%20or%20just%20see%20it...%20what%20shows%20up%3F%20The%20functions%20are%20in%20ENGLISH%20!!%20SPO%20%3CEM%3Eautomatically%3C%2FEM%3E%20%22translates%22%20them%20%3CEM%3Eright%20after%3C%2FEM%3E%20a%20column%20is%20created%20%3Apersevering_face%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22msauaf_1-1625246600131.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293147i4BF01A9067805267%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22msauaf_1-1625246600131.png%22%20alt%3D%22msauaf_1-1625246600131.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPLEASE%20ALSO%20NOTICE%20above%20that%20the%20%22non-english%22%20%3CEM%3Eseparator%3C%2FEM%3E%26nbsp%3Bin%20formulas%20is%20%22%3CSTRONG%3E%3B%3C%2FSTRONG%3E%22%20while%20in%20english%20is%20%22%3CSTRONG%3E%2C%3C%2FSTRONG%3E%22%20%3A%5C%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENow%20if%20someone%20try%20to%20add%20this%20column%20to%20ANY%20site%20list%2C%20SPO%20will%20DENY%20since%20it%20will%20claim%20there's%20a%20formula%20syntax%20error%20%3Apouting_face%3A%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22msauaf_2-1625246867014.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293148i21F8EB588292B0F8%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22msauaf_2-1625246867014.png%22%20alt%3D%22msauaf_2-1625246867014.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E(adding%20a%20column%20to%20a%20list%20selecting%20%22X%22%20from%20site%20columns)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22msauaf_3-1625246956855.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F293149iCCA9B5B585D00D57%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22msauaf_3-1625246956855.png%22%20alt%3D%22msauaf_3-1625246956855.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E(formula%20error%20after%20Ok%20to%20add%20that%20site%20column%20to%20a%20list)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhy%20this%20matters%3A%3C%2FP%3E%3CP%3E-%20whenever%20we%20need%20a%20formula%20to%20be%20used%20in%20several%20lists%2C%20we%20need%20to%20MANUALLY%20%22replicate%22%20such%20localized%20formulas%20in%20ALL%20lists%20in%20ALL%20sites%20where%20it's%20needed%20-%20we%20are%20NOT%20able%20to%20LEVERAGE%20site%20columns%3C%2FP%3E%3CP%3E-%20%3CEM%3Eworst%3C%2FEM%3E%2C%20we're%20not%20able%20to%20leverage%20sites'%20TYPE%20CONTENTS%20containning%20such%20calculated%20%3CEM%3Esite%3C%2FEM%3E%20columns.%20If%20we%20try%20to%20do%20this%20by%20allowing%20such%20a%20type%20in%20a%20managed%26nbsp%3B%20list%2C%20the%20calculated%20columns%20in%20the%20type%20with%20formulas%20with%20such%20localized%20functions%20will%20NOT%20be%20added%20to%20the%20list%20columns...%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2511507%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Contributor

We've a Pt-Br tenant. All Excel functions are (unfortunately) localized. If one creates a site column whose formula uses such localized functions, it cannot be added to lists. This is a BIG issue that has stayed for yet a very long time. Any update on if this problem will be ever fixed by some means?

 

An example: say you create a calculated, single text line site column "X" where its formula is like this (see that we are FORCED by SPO to use localized function names otherwise it will return an error message about wrong syntax):

msauaf_0-1625246114784.png

 

THEN you go back to EDIT or just see it... what shows up? The functions are in ENGLISH !! SPO automatically "translates" them right after a column is created :persevering_face:

 

msauaf_1-1625246600131.png

 

PLEASE ALSO NOTICE above that the "non-english" separator in formulas is ";" while in english is "," :\

 

Now if someone try to add this column to ANY site list, SPO will DENY since it will claim there's a formula syntax error :pouting_face::

 

msauaf_2-1625246867014.png

(adding a column to a list selecting "X" from site columns)

 

msauaf_3-1625246956855.png

(formula error after Ok to add that site column to a list)

 

Why this matters:

- whenever we need a formula to be used in several lists, we need to MANUALLY "replicate" such localized formulas in ALL lists in ALL sites where it's needed - we are NOT able to LEVERAGE site columns

- worst, we're not able to leverage sites' TYPE CONTENTS containning such calculated site columns. If we try to do this by allowing such a type in a managed  list, the calculated columns in the type with formulas with such localized functions will NOT be added to the list columns...

0 Replies