+1Newbie here! I need to get the word 'County' inserted into this List formula after the [County] field so that it shows up as, Chicago, Cook County, IL instead of Chicago, Cook, IL. Can anyone help? Thanks!
List(", ",[Address: City], [County], [Address: State/Region])
Best answer by MarkShnierYou
np,
var text County = IF(Trim([County])<>"", [County] & " County");
List(", ",[Address: City], $County, [Address: State/Region])
//the reason for the extra complexity is to deal with the possibility that the County is blank, in which case adding the word County would be confusing.
+22np,
var text County = IF(Trim([County])<>"", [County] & " County");
List(", ",[Address: City], $County, [Address: State/Region])
//the reason for the extra complexity is to deal with the possibility that the County is blank, in which case adding the word County would be confusing.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
