Evening,
I want to populate an excel spreadsheet from a form published.
I want to use my own headings and also need excel to be a live document.
The form will be date / start point / end point. I would also be sorting it by date so I can just view the ones on the current date.
I know there is an open in excel button from forms but this is just accurate at the point of opening and includes details such as time of submitting the form and name and others.
So, is it possible to connect to documents.
Is there a formula I need to enter to say fill this box with the answer to question 1 from the form.
