Just to piggy back off this a bet as I would like to that this one step farther. I have this formula now that works excellently:
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],"")
Though I only want it go through this formula if another field is blank and if it is not blank display its value. So I have been trying a nested if statement and it does not seem to be working, here is what I am going with:
If (Trim([Type of Claim or Project])="",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],""),[Type of Claim or Project])
Is it a structuring issue or is there a better solution?
