• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 319
  • Last Modified:

Set value of a column based on lookup value of another column.

Hello -

Here is what I am trying to do (in a simple example) -

Existing list List A -
Color Name  Color Number
Red                   1
Blue                  2
Green               3

List B -
A User enters in information, and one of the required fields is "Color".  This column is set up as a lookup of the "Color Name" values in List A.  We would like the next field in List B to be automatically set to the "Color Number" field that coorosponds with the users choice in the Color Name column.

Is there a way to do this?  (With out custom programing - or simple code at least as I know Designer but I am NOT a programmer.)

Thanks in advance!
0
dasmail2000
Asked:
dasmail2000
  • 3
  • 2
1 Solution
 
Robbie_LeggettCommented:
Just use a calculated column.
 
IF Colour = Red value = 1
IF colour = Blue value = 2
IF colour = Green value = 3
 
:-)
0
 
Robbie_LeggettCommented:
An easier way would be to use a SharePoint Designer workflow using the above parameters, so that when the item is saved it sets the value of the colour code field.
 
:-)
0
 
dasmail2000Author Commented:
Thougt of that and we could do that...but "List A" may change over time and I'd like to avoid having to go in and edit that column every time it does.  I would rather make it be a dynamic lookup of the values.

Any other thoughts?
0
 
dasmail2000Author Commented:
Previous comment was on your first post.


On the second post - Geat idea!  I did not even think on doing that and it should work fine.

I am going to give that a try - thanks!!
0
 
Robbie_LeggettCommented:
You're very welcome. Come back to me with any issues.
 
:-)
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now