Forum Discussion

JenSimoni2's avatar
JenSimoni2
Qrew Member
12 hours ago

Formula Assistance

Newbie 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])

formulas
  • MarkShnier__You's avatar
    MarkShnier__You
    11 hours ago

    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. 

  • MarkShnier__You's avatar
    MarkShnier__You
    Icon for Qrew Legend rankQrew Legend
    11 hours ago

    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.