10 Replies Latest reply on Oct 31, 2018 5:28 AM by Nic G

    Calculated Field to pull Actual Field

    Nic G

      Not a great title, but I'm not really sure how to explain.

       

      I've mocked up an Attachment - basically I have a name which has a relationship to another name (Downstream Relationship), I've then trimmed the field to make it like the actual Name (DD_Rename2) - what I want is the Match DD field to then pull the actual name field so I can then grab more details about the item in following columns.

       

      I've had a go at creating the calculated field but as you can see I get null (Match DD).

       

      Could someone advise where I'm going wrong or if there is a better way to do this - I'm on 10.5