SOLVED

Calculated columns now appearing in Edit form in New Experience view on Sharepoint Online list

%3CLINGO-SUB%20id%3D%22lingo-sub-1481355%22%20slang%3D%22en-US%22%3ECalculated%20columns%20now%20appearing%20in%20Edit%20form%20in%20New%20Experience%20view%20on%20Sharepoint%20Online%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481355%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3ERecently%20I%20have%20noticed%20that%20calculated%20columns%20are%20now%20appearing%20in%20my%20Edit%20form.......not%20the%20New%20form%2C%20when%20using%20the%20New%20Experience%20view%20for%20my%20Sharepoint%20Online%20List%26nbsp%3B%20The%20Classic%20view%20does%20not%20show%20these%20fields.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20why%20Microsoft%20changed%20this%20so%20I%20tried%20to%20fix%20it%20myself.%26nbsp%3B%20However%2C%20when%20I%20went%20to%20the%20field%20in%20Content%20Type%20the%20selection%20for%20%22Hidden%20(Will%20not%20appear%20in%20forms)%20is%20grayed%20out%20and%20you%20are%20unable%20to%20change.%26nbsp%3B%20This%20is%20the%20same%20behavior%20in%20older%20Sharepoint%20so%20it%20didnt%20surprise%20me%20but%20how%20do%20I%20get%20these%20fields%20out%20of%20my%20Edit%20form%20now%3F%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20need%20the%20ability%20to%20have%20them%20there%20or%20not%20just%20like%20any%20other%20fields.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1481355%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1481946%22%20slang%3D%22en-US%22%3ERe%3A%20Calculated%20columns%20now%20appearing%20in%20Edit%20form%20in%20New%20Experience%20view%20on%20Sharepoint%20Online%20list%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481946%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F706913%22%20target%3D%22_blank%22%3E%40cmaly%3C%2FA%3EThere%20is%20a%20way%20so%20I%20created%20a%20small%20example%20with%20two%20number%20columns%20and%20one%20calculated%20column%20which%20adds%20the%20column%20values%3A%3C%2FP%3E%3CP%3EThe%20%3CSTRONG%3Enew%20form%3C%2FSTRONG%3E%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1592856078965.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200150i0DFEAC2E58442BB7%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1592856078965.png%22%20alt%3D%22Vikram_Samal_0-1592856078965.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ENow%20the%20%3CSTRONG%3Eedit%20form%3C%2FSTRONG%3E%20follow%20the%20below%20steps%3A%20Open%20the%20edit%20form%20and%20then%20Click%20on%20the%20Edi%20Columns%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_1-1592856127359.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200154iDBA5BC2C4606CE46%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_1-1592856127359.png%22%20alt%3D%22Vikram_Samal_1-1592856127359.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20Uncheck%20Calculated%20Column%20and%20Save%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_2-1592856169063.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200155iD904B3E53ADE8DFB%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_2-1592856169063.png%22%20alt%3D%22Vikram_Samal_2-1592856169063.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EThen%20the%20%3CSTRONG%3EEdit%20form%3C%2FSTRONG%3E%20looks%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_3-1592856220409.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200156iC7FEFE74E08D8A75%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_3-1592856220409.png%22%20alt%3D%22Vikram_Samal_3-1592856220409.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3CBR%20%2F%3EVik%3CBR%20%2F%3EIf%20this%20post%20helps%2C%3CSTRONG%3E%20then%20please%20consider%20Accept%20it%20as%20the%20solution%3C%2FSTRONG%3E%20to%20help%20the%20other%20members%20find%20it%20more%20quickly.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Contributor

Hi,

Recently I have noticed that calculated columns are now appearing in my Edit form.......not the New form, when using the New Experience view for my Sharepoint Online List  The Classic view does not show these fields.

 

Not sure why Microsoft changed this so I tried to fix it myself.  However, when I went to the field in Content Type the selection for "Hidden (Will not appear in forms) is grayed out and you are unable to change.  This is the same behavior in older Sharepoint so it didnt surprise me but how do I get these fields out of my Edit form now?  

 

We need the ability to have them there or not just like any other fields.  

2 Replies
Highlighted
Solution

@cmalyThere is a way so I created a small example with two number columns and one calculated column which adds the column values:

The new form looks like this:

Vikram_Samal_0-1592856078965.png

Now the edit form follow the below steps: Open the edit form and then Click on the Edi Columns

Vikram_Samal_1-1592856127359.png

Then Uncheck Calculated Column and Save

Vikram_Samal_2-1592856169063.png

Then the Edit form looks like this:

Vikram_Samal_3-1592856220409.png

 

Thanks,
Vik
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Highlighted

@Vikram_Samal  Thank you so much!  I hadn't thought to look there.  Glad there actually is a solution to this one as sometimes that is not the case when changes are made :lol: