How to autofill a date from another sheet into a column
Is there a formula to autofill a date from another sheet into a column?
I currently have a sheet with dates for quarterly tests (Sheet A). I also have a sheet that information is entered via a form (Sheet B). What I would like to happen is when an employee fills out the form and it populates on Sheet B, the quarterly test column autofills with a specific date from Sheet A. Is this possible?
Since I've been unable to figure out a formula, I set up an automation to notify me when there is a new entry, so that I can fill out the date column.
Help Article Resources
Check out the Formula Handbook template!