Auto fill date from forms
I am trying to set up a formula that pulls data from a form / sheet to a master sheet. When a user fills out a form (see pic)
I would like the date to auto populate in the corresponding column on a different sheet.
Example: The "flight review" box is checked on the form and submitted. On the master sheet, the date the form was submitted is filled into that column. It would be helpful if it matched the user name in the "pilot" box as well. Thx.
Help Article Resources
Check out the Formula Handbook template!