[2 days left] What’s wrong with your cloud strategy? Learn why multicloud solutions matter with Nimble Storage.Register Now

x
?
Solved

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

Posted on 2009-05-11
5
Medium Priority
?
310 Views
Last Modified: 2012-05-06
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
Comment
Question by:dasmail2000
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 25

Expert Comment

by:Robbie_Leggett
ID: 24354673
Just use a calculated column.
 
IF Colour = Red value = 1
IF colour = Blue value = 2
IF colour = Green value = 3
 
:-)
0
 
LVL 25

Accepted Solution

by:
Robbie_Leggett earned 2000 total points
ID: 24354697
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
 
LVL 1

Author Comment

by:dasmail2000
ID: 24354715
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
 
LVL 1

Author Comment

by:dasmail2000
ID: 24354744
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
 
LVL 25

Expert Comment

by:Robbie_Leggett
ID: 24354795
You're very welcome. Come back to me with any issues.
 
:-)
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The core idea of this article is to make you acquainted with the best way in which you can export Exchange mailbox to PST format.
If something goes wrong with Exchange, your IT resources are in trouble.All Exchange server migration processes are not designed to be identical and though migrating email from on-premises Exchange mailbox to Cloud’s Office 365 is relatively simple…
In this video we show how to create an Address List in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Organization >> Ad…
To show how to create a transport rule in Exchange 2013. We show this process by using the Exchange Admin Center. Log into Exchange Admin Center.: First we need to log into the Exchange Admin Center. Navigate to the Mail Flow >> Rules tab.:  To cr…

656 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question