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?
Example columns
Sheet A
Sheet B
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.
Best Answer
-
Hi Carlene,
I do this by creating cross sheet references. You can start by creating an "IF statement on Sheet B:
When you get this far click that "Reference Another Sheet" link and select Sheet A, click on the cell you would like to reference and give it a name:
You may get en error if your date field is restricted to dates only. Just click allow:
Now you can finish your formula by double clicking on the cell:
You might get that same error about dates again. To finish this off, just right click on your cell and convert this to a column formula:
Now every new line will be auto-filled with your cross sheet reference. Repeat these steps for your other dates.
Hope that helps!
Answers
-
Hi Carlene,
I do this by creating cross sheet references. You can start by creating an "IF statement on Sheet B:
When you get this far click that "Reference Another Sheet" link and select Sheet A, click on the cell you would like to reference and give it a name:
You may get en error if your date field is restricted to dates only. Just click allow:
Now you can finish your formula by double clicking on the cell:
You might get that same error about dates again. To finish this off, just right click on your cell and convert this to a column formula:
Now every new line will be auto-filled with your cross sheet reference. Repeat these steps for your other dates.
Hope that helps!
-
It worked!!! Thank you!!
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 64 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!