I'm having trouble using a "Lookup" type field to lookup values from another list.
I have two lists.
'Invoices' list shows all the invoices' being entered by colleagues with all the general information.
'Problems' list shows a list of the problematic invoice numbers (it's alpha numeric) and a description of the problem entered by another "audit" team.
What I'd like to do: Add a "lookup" column in the 'Invoice' list that shows the description of the problem (IF any exist in the 'Problem' list) once a new item is added (or updated later since some items don't always have an invoice number).
What I did so far:
- I added a "lookup" column called "Invoice Check" (which also added 'Invoice Check:Problem Description').
- I created a workflow to "Set 'Invoice Check' to 'Invoice#'"
Unfortunately, the workflow did not seem to work because I don't think it's returning the intended value.
My Google search results were very confusing as I am still a junior level in SP, so I'm hoping someone could help me figure this out.
Your help is greatly appreciated.
EDIT: Corrected the first sentence to make more sense.