Forum Discussion
TeamProMember
Aug 25, 2021Brass Contributor
SharePoint - Item Tagging
Hi everybody, hoping to get some suggestions on a 'problem' I have to solve. Basically, our company has a list of say 2000 products. Each of those products has an external certification. Ther...
- Aug 26, 2021Sounds like you need to create a Lookup column in your products list. Configure the Lookup column to use the Certificates List (or Library) as the lookup data.
Once that is done, you can use Edit in Grid View to bulk edit your products list.
SteveKnutson
Aug 26, 2021MVP
Sounds like you need to create a Lookup column in your products list. Configure the Lookup column to use the Certificates List (or Library) as the lookup data.
Once that is done, you can use Edit in Grid View to bulk edit your products list.
Once that is done, you can use Edit in Grid View to bulk edit your products list.
TeamProMember
Aug 26, 2021Brass Contributor
Thanks Steve, makes perfect sense now you mention it. One more question, is it possible to display a column in 1 SPT list, in a 2nd SPT list? (both in the same site) i.e. the certificate list has the expiration date column. I want to show this on the product list if possible?
- SteveKnutsonAug 26, 2021MVPYes, when you create the Lookup Column you can specify additional columns to display. Here is the full reference.
https://support.microsoft.com/en-us/office/create-list-relationships-by-using-unique-and-lookup-columns-80a3e0a6-8016-41fb-ad09-8bf16d490632