Extracting City and State in Table View

  • Profile Image
    Asked on December 30, 2020 at 05:07 PM


    I am using a form that uses the standard address widget to pick up full address information. As you may know very key address data has its own field in the Form, but when swithcing to Submissions Table Mode, the whole address data is in the same coloumn, separated with commas.

    This makes it impossible to analyze and group data by City or State.

    I tried adding a Formula column, but with no knowledge hoy to make it work.

    Can you help me please?

    Thank you.


  • Profile Image
    Answered on December 30, 2020 at 09:24 PM

    Hi Martin,

    You can click on the 'expand column' option to achieve the result that you want:


    Please let us know if you need further assistance.