Column calculated from other existing columns

Question

Hello,&nbsp;I am very annoyed :&nbsp;I have a SharePoint list and&nbsp;I would like to get a calculated column whose content adds that of two other columns already existing in my list.&nbsp;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&nbsp;Error message&nbsp;Thanks in advance for your help&nbsp;&nbsp;

robelliott · Answer

Vicgbt&nbsp;what column type are those 2 other columns in your list?RobLos GallardosIntranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

vicgbt · Answer

Hello&nbsp;RobElliott&nbsp;&nbsp;These are two numerical columns that I created myself

gretchunkim · Answer

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!

vicgbt · Answer

gretchunkim&nbsp;&nbsp;No it's not a calculated column, it's only a number that I entered myself&nbsp;Thank you, I will try your solution then

robelliott · Answer

Vicgbt&nbsp;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.&nbsp;&nbsp;RobLos GallardosIntranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Forum Discussion

Column calculated from other existing columns

6 Replies

Resources