Forum Discussion

Copper Contributor

Oct 01, 2021

Column calculated from other existing columns

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

Silver Contributor

Oct 01, 2021

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)

Vicgbt
Copper Contributor
Oct 02, 2021
Hello RobElliott

These are two numerical columns that I created myself
- gretchunkim
  Brass Contributor
  Oct 03, 2021
  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
    Copper Contributor
    Oct 04, 2021
    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