Split the appointment date and time into separate colum

Hi

How does one split the appointment date and time into separate columns of the google spreadsheet rather than have it all in one column.

Thank you

Hello there,

I'm afraid that there's no feature available to let us separate date and time of appointment slot.

As a workaround, you can add a Date Picker and a Time field to your form. Then, add the conditions below so that you'll be able to copy the chosen appointment date and time separately.

Guide: How-to-insert-text-or-calculation-into-a-field-using-conditional-logic

Result:

I hope this helps.

Should you have further inquiries, kindly let us know.