Looking to parse cell data in an excel report

  • Profile Image
    jwardwel
    Asked on April 06, 2018 at 12:49 PM

    Hi,

      I'm using a configurable list widget as a calendaring option because it allows me to create recurring bookings.  When I create an excel report of the form submissions the data results for the "Delivery Date" question are listed all in one cell so I can't sort to look at just one particular day's deliveries.  Is it possible with one of your apps to create an excel report that will break out each delivery into his own row in excel so that I can sort chronologically or I can filter on a certain day and see all of that day's deliveries only?  <Pic attached>

    Thanks,
    Jeff


  • Profile Image
    Richie_P
    Answered on April 06, 2018 at 01:41 PM

    Unfortunately the configurable list or any other widgets with multiple options will normally be treated as as single field when exported to spreadsheet.

    However, you can use the Split text to column by Google Sheets to separate the fields.

    Hope this information helps.

    Please let us know if we can be of further assistance.