renamed Created column: error if used by calculated columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2523383%22%20slang%3D%22en-US%22%3Ecannot%20refer%20in%20calculated%20columns%20a%20Created%20column%20that%20was%20renamed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2523383%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20rename%20the%20Created%20column%20in%20a%20list%2C%20I%20cannot%20use%20it%20to%20create%20a%20calculated%20column%20that%20refers%20to%20it...%20Is%20this%20some%20%22feature%22%20of%20SPO%20or%20really%20a%20bug%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20for%20an%20exmaple%3A%20our%20tenant%20is%20Pt-Br.%20This%20means%20the%20native%2Fdefault%20name%20for%20the%20built-in%20datetime%20column%20for%20items'%20creation%20is%20localized%2C%20%22Criado%22.%20Below%2C%20I've%20renamed%20that%20%22Criado%22%20column%20to%20%22Created%22%20and%20then%20tried%20to%20create%20a%20calculated%20column%20referring%20to%20it.%20The%20error%20returned%20says%20such%20column%26nbsp%3B%20(Created%20-%20the%20new%20name)%20%22doesn't%20exist%22%20(even%20though%20this%20new%20column%20name%20%3CEM%3Ewas%3C%2FEM%3E%26nbsp%3Bin%20the%20pick%20list%20of%20columns%20for%20the%20formula)%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%22mescwbif_0-1625665946581.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294025iA53D63AD9F59CFB7%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mescwbif_0-1625665946581.png%22%20alt%3D%22mescwbif_0-1625665946581.png%22%20%2F%3E%3C%2FSPAN%3E%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%22mescwbif_1-1625666073432.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294027i98293A832C41E7A2%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mescwbif_1-1625666073432.png%22%20alt%3D%22mescwbif_1-1625666073432.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20if%20I%20rename%20the%20%22Created%22%20column%20%3CEM%3Eback%3C%2FEM%3E%20to%20its%20native%2C%20localized%20name%20(%22Criado%22)%2C%20then%20try%20to%20create%20a%20calculated%20column%20referring%20to%20it%2C%20I%20succeed%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EY'all%20can%20test%20renaming%20the%20Created%20column%20to%20whichever%20you%20want%20and%20then%20try%20to%20use%20it%20in%20some%20calculated%20column%20formula.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2523383%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

If I rename the Created column in a list, I cannot use it to create a calculated column that refers to it... Is this some "feature" of SPO or really a bug?

 

Just for an exmaple: our tenant is Pt-Br. This means the native/default name for the built-in datetime column for items' creation is localized, "Criado". Below, I've renamed that "Criado" column to "Created" and then tried to create a calculated column referring to it. The error returned says such column  (Created - the new name) "doesn't exist" (even though this new column name was in the pick list of columns for the formula):

 

mescwbif_0-1625665946581.png

 

mescwbif_1-1625666073432.png

 

and if I rename the "Created" column back to its native, localized name ("Criado"), then try to create a calculated column referring to it, I succeed

 

Y'all can test renaming the Created column to whichever you want and then try to use it in some calculated column formula.

 

 

0 Replies