Extracting City and State in Table View

Hi,

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.

Martin

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.

Best,