Forum Discussion

Periclesin's avatar
Periclesin
Copper Contributor
Jul 04, 2024

calculated columns

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
  • Periclesin 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)

  • Rob_Elliott's avatar
    Rob_Elliott
    Bronze Contributor

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

Resources