Quick Tip (3): lookup field to a site on top

Imagine this case, like a customer of mine had: You have all kinds of project sites for all the projects in your company. Of course you have a site on top that links to all these sites, shows you some additional info etc..

Now, my client wanted to manage all issues on the top level site, while all tasks (multiple tasks for each issue) are on the project sites.

project management vs project sites

Custom development, was my first idea..until a colleague came with a brilliant idea:

“You can create a site column on the top site (type=lookup to the issue list), and reuse it on the project sites. That way you can do it ootb!”

Good to hear that some people actually think through the MOSS Matrix! I guess he took the red pill instead of the blue one 😉

About: Marijn

Marijn Somers (MVP) has over 14 years experience in the SharePoint world, starting out with SP2007. Over the years the focus has grown to Office 365, with a focus on collaboration and document management. He is a business consultant at Balestra and Principal Content Provider for "Mijn 365 Coach" that offers dutch employee video training. His main work tracks are around user adoption, training and coaching and governance. He is also not afraid to dig deeper in the technicalities with PowerShell, adaptive cards or custom formatting in lists and libraries. You can listen to him on the biweekly "Office 365 Distilled" podcast.