Adding Formulas in Google Sheets
When you submit this Google Form, it will add a new row to this Google Sheet and cell values are auto-filled using Array Formulas.

Google Sheet: https://drive.google.com/open?id=1RQ6K_6U68NUChi0PhUeyYADhOskbwh3fe_mpUXMA8oU

Tutorial: https://www.labnol.org/google-form-formulas-050520
What is your name? *
Which city is called the "Big Apple" *
Check-in Date *
MM
/
DD
/
YYYY
Check-out Date *
MM
/
DD
/
YYYY
Submit
Never submit passwords through Google Forms.
This form was created inside of Digital Inspiration. Report Abuse