Others

Can SharePoint Calculated Columns Use Values From Other List Items?

Olivia Miller Sep 25, 2026 870 views

Question details

The user needs to know if a SharePoint calculated column can reference or automatically update values in other related list items, such as shifting agenda times when a single item is modified.

Can SharePoint Calculated Columns Use Values from Other List Items?

Product: Microsoft SharePoint
Device & OS: not provided
Scenario: Creating dynamic SharePoint lists where changing one item's data automatically recalculates or updates related rows in the same list.
Observed behavior: SharePoint calculated columns only perform calculations based on fields within the same exact list item and cannot pull data from other list items or lookup values natively.

Before you start

Before attempting to automate your list updates, ensure you have the necessary Microsoft 365 permissions to create and manage Power Automate workflows, as native SharePoint settings cannot achieve cross-item calculations.

Solution 1Recommended

Use Power Automate to Update Related SharePoint List Items

Since SharePoint calculated columns cannot reference other items, you must use a Power Automate flow to trigger updates across related list items when a change occurs.

SharePoint restricts calculated columns to referencing data within the same row to ensure database performance and avoid infinite loops. To shift or update data in other rows based on a specific change, workflow automation is required.

Create a new Power Automate Flow

Log in to Power Automate and create an 'Automated cloud flow'. Choose the trigger 'When an item is created or modified' and link it to your target SharePoint Site Address and List Name.

Retrieve related list items

Add the 'Get items' action. Configure the Filter Query to fetch the specific related list items that need to be updated (for example, items with a scheduled time after the modified item).

Apply changes to related items

Add an 'Apply to each' loop using the output from the 'Get items' action. Inside the loop, add an 'Update item' action to recalculate and apply the new values (like shifted agenda times) to each related item.

Use Power Automate to Update Related SharePoint List Items

Seek Community Guidance: If you are dealing with highly complex logic or multiple linked lists, consider asking for implementation guidance in the official Microsoft Power Automate community forums.

Free Microsoft Office alternative

Looking for a Lightweight Alternative to Microsoft Office?

While complex automated list workflows require SharePoint and Power Automate, standard spreadsheet calculations and cross-referencing can be handled easily in WPS Office. Enjoy a free, lightweight suite with a familiar interface for all your document needs.

1. Download WPS Office: Visit the official WPS Office website and download the free installer for your operating system.
2. Open WPS Spreadsheet: Launch WPS Spreadsheet to create dynamic data lists that easily reference other rows and sheets using built-in formulas.
3. Save and Share: Save your work seamlessly in .xlsx format to ensure full compatibility with Microsoft Excel users.

Excellent alternative for spreadsheet data management without complex SharePoint restrictionsFully compatible with Microsoft Excel (.xlsx), Word (.docx), and PowerPoint (.pptx) formatsFree and lightweight office suite with a familiar tabbed user interfaceAdvanced spreadsheet formulas for dynamic cross-sheet calculations

microsoft office alternative - wps office

Frequently Asked Questions

Can I use lookup column values in a SharePoint calculated column?

No, native SharePoint calculated columns cannot reference Lookup, Person/Group, or Multiple Lines of Text columns. You must use Power Automate to copy those values into standard text columns before calculations can run.

Is there a VLOOKUP equivalent function in SharePoint lists?

SharePoint lists do not feature a built-in VLOOKUP function for calculated columns. To link or reference data between lists, you must use standard Lookup columns or automate data fetching with Power Automate flows.

Why doesn't my calculated column update when I change a related item?

Calculated columns only recalculate when the specific item containing the formula is created or modified. They do not automatically trigger updates based on external changes to other items or lists.

Office Quick Solutions