I am working on a form that uses a lookup field called "Country of Interest" connected to the sharepoint site. This field pulls in all of the countries connected to a different sharepoint list that are associated with their respective Directors. I am trying to use the lookup function to populate the name of the director once the country has been selected. Is my formula off? Any advice is greatly appreciated!
here is a screenshot of the formula
Solved! Go to Solution.
We never could get the lookup() formula working reliably on a text control that referenced a list lookup / dropdown.
Instead, we created a second list lookup / dropdown and set the lookup / filter there and then connected that to a text column. The only drawback was the user must take the action to select the 1 and only item in the dropdown (which we switched to a radio button), but our users adjusted to it.
See attached screenshots.
Thanks for the suggestion - sounds like you originally were doing a cascade? I think I'll follow this approach. Kind of seems silly that this function wouldn't work on a text field though.