Column calculated from other existing columns

%3CLINGO-SUB%20id%3D%22lingo-sub-2802971%22%20slang%3D%22fr-FR%22%3EColumn%20calculated%20from%20other%20existing%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2802971%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20very%20annoyed%20%3A%20I%20have%20a%20SharePoint%20list%20and%20I%20would%20like%20to%20get%20a%20calculated%20column%20whose%20content%20adds%20that%20of%20two%20other%20columns%20already%20existing%20in%20my%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBut%20when%20I%20select%20a%20calculated%20column%2C%20choose%20the%20columns%20on%20which%20I%20want%20to%20do%20my%20calculation%20and%20then%20validate%2C%20I%20get%20the%20error%20message%20below%20which%20tells%20me%20that%20the%20columns%20do%20not%20exist.%20How%20do%20you%20explain%20this%20please%20%3F%3F%3C%2FP%3E%3CP%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22colonnes%20calcul%C3%A9e.PNG%22%20style%3D%22width%3A%20836px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314218i57CAB8E18303FAD4%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22colonnes%20calcul%C3%A9e.PNG%22%20alt%3D%22Column%20calculation%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EColumn%20calculation%3C%2FSPAN%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-center%22%20image-alt%3D%22message%20d'erreur%20colonnes%20calcul%C3%A9es.PNG%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F314219i30C15719C8694C13%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22message%20d'erreur%20colonnes%20calcul%C3%A9es.PNG%22%20alt%3D%22Error%20message%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EError%20message%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThanks%20in%20advance%20for%20your%20help%3C%2FSPAN%3E%26nbsp%3B%3CIMG%20class%3D%22lia-deferred-image%20lia-image-emoji%22%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Fhtml%2F%402F5B53C90739358292524B2CDF7F85DA%2Fimages%2Femoticons%2Fcry_40x40.gif%22%20alt%3D%22%3Acry%3A%22%20title%3D%22%3Acry%3A%22%20%2F%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2802971%22%20slang%3D%22fr-FR%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2803325%22%20slang%3D%22en-US%22%3ERe%3A%20Column%20calculated%20from%20other%20existing%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2803325%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1172363%22%20target%3D%22_blank%22%3E%40Vicgbt%3C%2FA%3E%26nbsp%3Bwhat%20column%20type%20are%20those%202%20other%20columns%20in%20your%20list%3F%3CBR%20%2F%3E%3CBR%20%2F%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2805516%22%20slang%3D%22fr-FR%22%3ERe%3A%20Column%20calculated%20from%20other%20existing%20columns%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2805516%22%20slang%3D%22fr-FR%22%3E%3CP%3EHello%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174092%22%20target%3D%22_blank%22%3E%40RobElliott%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EThese%20are%20two%20numerical%20columns%20that%20I%20created%20myself%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hello,

 

I am very annoyed : I have a SharePoint list and I would like to get a calculated column whose content adds that of two other columns already existing in my list.

 

But when I select a calculated column, choose the columns on which I want to do my calculation and then validate, I get the error message below which tells me that the columns do not exist. How do you explain this please ??


Column calculationColumn calculation

 

Error messageError message

 

Thanks in advance for your help :cry:

 

6 Replies

@Vicgbt what column type are those 2 other columns in your list?

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

Hello @RobElliott 

 

These are two numerical columns that I created myself

Is the column itself is a calculated column? I see the column of interest here is called "Daily REQ/ FT Advance...", and that lead me to assume that is the case.

From my experience, you can work around it by creating a new calculated column type using the column name (eg., =[$missingcolumn] in the formula. Then use this column in the secondary calculation.

Good luck!

@gretchunkim 

 

No it's not a calculated column, it's only a number that I entered myself

 

Thank you, I will try your solution then

@Vicgbt go into your list settings, select each of the columns and check what the internal name is at the end of the address bar after Field=. If you have changed the name of a column the original internal name will stay the same, and this might be the cause of your problem. It is the internal name that needs to be used in your calculated column.

 

internalColumnName.png

 

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

@RobElliott Indeed Robb, the internal name is not the same :

 

Capture.PNG

 

Capture2.PNG

 

But when i change the formula i still get the same error message. Do you see what's wrong now ?

 

Capture3.PNG

 

Vicgbt_0-1633423057163.png

 

Thanks in advance