Menu
I have three lists that look like this:
Initiatives
-----------
Initiative (single line text)
Themes
------
Theme (single line text)
Initiative (Lookup from Initiatives:Initiative)
Points (number)
Features
--------
Feature (single line text)
Theme (Lookup from Themes:Theme)
Points (Lookup from Themes:Points) # <- This here works fine.
Initiative (Lookup from Themes:Initiative) # <- This here is busted and can't do.
See that last line there... Initiative (Lookup from Themes:Initiative) <- that's me trying to get the initiative associated with the Theme. I've tried about a bazillion different things and just cannot figure out how to do this.
Is it even possible? If so, how?
FWIW - I am using SharePoint 2010 and can use anything from the web tools to SharePoint Designer. I'm an admin on the SharePoint Site but not on the Server.
312
First, Vlookup column is not supported in the SharePoint. You can only display column X in the list B through lookup column. You cannot calculate differences between two columns. Create a lookup column in the list B.
In the Modern SharePoint online list, a view can contain the maximum number of 12 lookup columns. Yes, the default value is also used for SharePoint Online, where the default value is increased from 8 to 12. We cannot use more than 12 lookup columns in a SharePoint online list view.
You can use lookup columns in SharePoint that consume values from other lists or libraries. When using such columns as a field in a canvas app, you can use a drop-down list with choices. To use the choices in a drop-down list, you have to use the function choices.
5. Click the two SharePoint lists you would like to include in the join, and then click the “Add” button. The lists are added to the Selected Data Sources list. Click "Next."
You cannot do that, what you need to do is use a cascading lookup field (a custom field that enables filtering one lookup according to the value[s] selected in the parent loookup. Then you can set up two lookup columns in your Features list, the first looking up the Initiatives list, the other - Themes list. Once you select a value in the Initiative, only the relevant values are available in Theme.
An example of a field like this is http://infowisesolutions.com/product.aspx?id=ConnectedFields2007 (from our company :)), but there are other solutions as well.
150
How about this... you create a column in Themes that is a calculated field that concatenates all three values you seek from the Themes table, i.e.
=[Theme]&" / "&[Points]&"/ "&[Initiatives]
In the Features List you create a Lookup column that pulls in the concatenated value. You then make the Theme, Points & Initiatives" columns calculated fields that parse the correct value from the concatenated lookup value.
Voila.
38
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
