This is a much more elegant approach, I did some tweaking as I would like it so that when the Type of Claim or Project field is blank then it goes through the type1, type2, type3, statement. If there is something in the Type of Claim or Project field then I would like it to be displayed. What I am working with now is:
var text TestTypes =
If(
Trim([Type3 - Third Type])="" and Trim([Type2 - Second Type])="" and Trim([Type1 - First Type])<>"",[Type1 - First Type],
Trim([Type3 - Third Type])="" and Trim([Type2 - Second Type])<>"" and Trim([Type1 - First Type])<>"",[Type2 - Second Type],
Trim([Type3 - Third Type])<>"" and Trim([Type2 - Second Type])<>"" and Trim([Type1 - First Type])<>"",[Type3 - Third Type]);
If(Trim([Type of Claim or Project])="", $TestTypes,[Type of Claim or Project])
If something is selected from the drop down in the Type of Claim or Project field it is filling in, though if I leave it blank and try to select a Type 1 the calculation field does not resolve and just reads ???
