Google Forms corresponding to a pre-set date on Sheets instead of being added consecutively

Question

Is it possible to have Google Form data inputs being added not one after the other but corresponding with the Date that is pre-filled on the response form?

Here you can see how the data is currently added from the Form responses, one after the other.

This is how I want it to look like.

I tried to pre-add the date in column B and would now like the responses from the Form to be added according to the corresponding date on the Sheet instead of consecutively. I've tried this with a test but the responses are still added consecutively as you can see here. Is this possible to achieve?

Answer 1

You want to create "dummy" form responses that will appear in the correct date order.

To do this you create a query where you combine two ranges (1=the original responses, 2=the dummy responses) by stacking them and ordering the result by date

The query looks something like this: =query({'Daily Production Report'!A1:B;Manual_Prod_Reports!A1:B},"select * where Col1 is not null order by Col1",1)

A few things to note:

• the data ranges are stacked by wrapping them in curly brackets, and separating them by a semi-colon (or a comma if your locale uses decimal comma instead of decimal point)
• the dummy responses are placed in the correct date order by using the order by clause
• Leave the original form responses as-is.
• Do your reporting from the query (which you might put on a new sheet)
• In this example, the responses are just two columns for the sake of brevity BUT in your 'live' spreadsheet the dummy responses must include all the columns from the "form responses" sheet - even though the cell with any content is the Timestamp.

---

Sample Production Report

Sample dummy responses

Sample query output