I would like to create a multiple date-picker that would translate to one cell in a google sheets

Hi There,

I am creating a Staff Time Off Request Form and am trying to achieve something particular.

We will need the form to be integrated into a shared Google Sheets and I am trying to limit the amount of cells that the form will create. One option I have been requested is to allow the staff members to choose multiple non consecutive dates.

I would like to know, what is my best option for limiting this to a single collumn output on a google sheets;

If I use multiple instances of the date picker and lable them Date1, Date2, Date3, Date4, that would translate to multiple collumns on the Google Sheets.

Do you have any recommendations?

Cheers!

Yes, each field would be translated into a column

An alternative would be to integrate the form with Google Drive and create a sub-folder, based on the Name field