Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Q&A for work
Connect and share knowledge within a single location that is structured and easy to search.
Can a calculated column look for a field in a separate list in another site collection or is it just limited to the same site collection in SharePoint online?
Per my knowledge, calculated column only refers to existing columns in the same list of same site collection in the SharePoint Online.
Required, but never shown