sharepoint online list calculated column cannot see columns from the site columns list in site settings?

Question

I'm pretty new to SharePoint Online, but use it in a fairly basic way to hold documents, lists and planners and various subsites etc.

From the POV of an SPO List, I realised quick quickly it was beneficial to create these in the main sites 'Site Settings, then Site Columns' area, so that the same created column and its configuration could be added again to another SPO list (as opposed to having to recreate the same thing over again from scratch).

Problem I've just discovered however, is that when I then went to use a column with a 'Calculated (calculation based on other columns)' value within any one individual SPO list, the list of columns shown within the configuration page associated to this only shows that of the columns within that one SPO list (ie, it does not show the columns created higher up the hierarchy in the 'Site Settings, then Site Columns' list.

Is there a way to enable the Calculated Column value 'see' the columns created in the 'Site Settings, then Site Columns' list?

Thanks in advance

Adam

Answer 1

Hello @Adam-5960 ,

Welcome to Q&A Forum!

Sorry, this is not possible.

Calculated column is a special type of column you can create on a list or library that will allow for the value of the field to be based on another value/field for the same row in the same list or library. In other words, only columns (fields) under the same list or library can be used for calculation.

For more on formulas and functions to use with the calculated field, see Examples of common formulas in SharePoint Lists. This article has many common formulas, as well as links to descriptions of all the functions that can be used in SharePoint.

Thanks,
Echo Du

=============================================

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.