Renaming a column breaks formulas that refer to it

%3CLINGO-SUB%20id%3D%22lingo-sub-2523543%22%20slang%3D%22en-US%22%3ERenaming%20a%20column%20breaks%20formulas%20that%20refer%20to%20it%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2523543%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20I%20rename%20a%20column%2C%20SPO%20does%20not%20update%20all%20formulas%20that%20refer%20to%20that%20column.%20Is%20this%20some%20of%20its%20%22features%22...%20or%20a%20bug%20indeed%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESay%20you%20create%202%20colums%3A%20one%20is%20single%20text%20line%20and%20the%20other%20is%20calculated%20which%20refers%20to%20the%20former.%20Then%20you%20rename%20the%20former%2C%20and%20go%20to%20edit%20the%20calculated.%20You'll%20see%20that%20the%20formula%20still%20refers%20to%20the%20old%20name%20of%20the%201st...%20(if%20you've%20dozens%20of%20formulas%20referring%20to%20that%20column%20in%20several%20lists%2C%20this%20is%20a%20nightmare!).%20And%20if%20you%20don't%20manually%20update%20the%20formulas%20in%20all%20columns%20that%20refer%20to%20the%20renamed%20one%2C%20existing%20and%20new%20items%20will%20be%20blank%20or%20get%20errors.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20instance%2C%20create%20a%20slt%20column%20%22xxx%22%20and%20a%20calculated%20%22yyy%22%20that%20equals%20to%20%22xxx%22%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-1625668427901.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294031i832074BD2929205B%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22mescwbif_0-1625668427901.png%22%20alt%3D%22mescwbif_0-1625668427901.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20you%20rename%20%22xxx%22%20to%20%22zzz%22%3A%26nbsp%3B%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_3-1625668816972.png%22%20style%3D%22width%3A%20213px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294035i49E09AC3B4E5D4B8%2Fimage-dimensions%2F213x125%3Fv%3Dv2%22%20width%3D%22213%22%20height%3D%22125%22%20role%3D%22button%22%20title%3D%22mescwbif_3-1625668816972.png%22%20alt%3D%22mescwbif_3-1625668816972.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnd%20as%20you%20go%20to%20the%20%22yyy%22%20definition%2C%20its%20formula%20still%20refers%20to%20the%20old%20name.%20You%20have%20to%20manually%20edit%20it%20to%20%22fix%22%2C%20to%20refer%20to%20the%20new%20name%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_2-1625668711676.png%22%20style%3D%22width%3A%20304px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F294034i9536C2A385475661%2Fimage-dimensions%2F304x337%3Fv%3Dv2%22%20width%3D%22304%22%20height%3D%22337%22%20role%3D%22button%22%20title%3D%22mescwbif_2-1625668711676.png%22%20alt%3D%22mescwbif_2-1625668711676.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2523543%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

If I rename a column, SPO does not update all formulas that refer to that column. Is this some of its "features"... or a bug indeed?

 

Say you create 2 colums: one is single text line and the other is calculated which refers to the former. Then you rename the former, and go to edit the calculated. You'll see that the formula still refers to the old name of the 1st... (if you've dozens of formulas referring to that column in several lists, this is a nightmare!). And if you don't manually update the formulas in all columns that refer to the renamed one, existing and new items will be blank or get errors.

 

For instance, create a slt column "xxx" and a calculated "yyy" that equals to "xxx":

 

mescwbif_0-1625668427901.png

Then you rename "xxx" to "zzz": 

 

mescwbif_3-1625668816972.png

 

And as you go to the "yyy" definition, its formula still refers to the old name. You have to manually edit it to "fix", to refer to the new name:

 

mescwbif_2-1625668711676.png

 

2 Replies

@mescwbif once you start to work with power platform apps like Power Apps and Power Automate you will realise the danger of renaming columns. Both of those will refer to the original internal name and so, very often, does SharePoint. It might sound flippant but plan your structure carefully in advance so you don't have to rename columns.

 

Rob
Los Gallardos
Intranet, SharePoint, Website and Power Platform Manager (and classic 1967 Morris Traveller driver)

Rob, I appreciate your comment and kind remind. I understand that any rename can impact stuff made outside of SPO. But this wouldn't hamper the idea, since many tenants even don't use powerapps/flow. Whenever one decides to build something outside of a system that refers to it, have to be aware of fields' renamings, to fix / control all "external" stuff as appropriated. This is usual in IT, for instance with SQL and front-end apps - however if one renames a column in a table from a DB, SQL automatically ensures at least all its references in its own SPs and triggers are updated accordingly (and if replicating to other server, propagates the rename to there too).

So, I can't really understand why would be that hard to make SPO do the same "inside" it (update references in calculated columns, pages, events etc) as well :)