Column calculated from other existing columns

[Vicgbt]

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 calculation

Error message

Thanks in advance for your help 

[#2]

@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)

[#3]

Hello @RobElliott 

These are two numerical columns that I created myself

[#4]

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!

[#5]

@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

[#6]

@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.

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

[#7]

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

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

Thanks in advance