I am really not sure this can be done out of the box but if anyone knows of any plugs ins or scripts that might accomplish this I would be extremely grateful.
So I have Project A - this project contains issues which hold the Project information like Programme Manager, Project Name, Lead Admin and such like.
In Project B - I have a tool to request items for projects, within this project I have a field called project name, currently this has been to be kept in sync manually with records in Project A.
What I would like to know is, is there a way to set up a select field in Project B that returns only the unique values from the Project Name field in Project A?