I was given this recently to do something similar and I adapted this to suit my needs....
IF(Squad Name="Squad A","Squad A",IF(Squad Name="Squad B","Squad B",IF(Squad Name="Squad C","Squad C",IF(Squad Name="Squad D","Squad D",IF(Squad Name ="", "No Selection","Multiple Squads"))))) I was pulling in...