Forum Discussion
John603
Jun 08, 2023Copper Contributor
Automatically assign values for one column based on another column with options from second list
Okay I will try to explain this as best as I can. I hope I am not re-asking a question but I couldn't find anything that matched my problem: I have two SharePoint Lists: List 1 = Requests - Coll...
ganeshsanap
Jun 09, 2023MVP
John603 What is the column/data type of Option and Option Coordinator column in the List 2?
If it is a single line of text, you can do this:
- Create a lookup column in list 1 which will point to list 2
- Use main column as option
- Extend lookup and use additional column for Option Coordinator in lookup settings:
Check these documentations for more information:
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.