SOLVED

calculated columns

Copper Contributor
Hello. I would like to know if sharepoint calculated columns can reference a previous element of that same column or another. In Excel, for example, I can make a formula that is B11=B10+A10.

But in a sharepoint list the column name is referenced to calculate something. 

Thanks in advance
3 Replies
best response confirmed by Pedro_Garcia_MacroMed (Copper Contributor)
Solution

@Pedro_Garcia_MacroMed a calculated column can only reference other columns of that item, it can't reference other items in the list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

ok, thanks.

@Pedro_Garcia_MacroMed,

 

I agree with @Rob_Elliott. Here is Microsoft official documentation for same: 

ganeshsanap_0-1720173270790.png

 

ReferenceIntroduction to SharePoint formulas and functions 


Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

1 best response

Accepted Solutions
best response confirmed by Pedro_Garcia_MacroMed (Copper Contributor)
Solution

@Pedro_Garcia_MacroMed a calculated column can only reference other columns of that item, it can't reference other items in the list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User.
Principal Consultant, SharePoint and Power Platform WSP Global (and classic 1967 Morris Traveller driver)

View solution in original post