Formulas Across/Within Sheets
Building an employee hiring database (sheet 2) off our hired applicants sheet (Sheet 1). After typing an email address in the first column of the sheet 2 , it should populate 4 or 5 subsequent columns across the same row in sheet 2. The column information and email address are both included in sheet 1. I have tried many permutations of formulas, and can't find the right one.
Suggestions? Thank you!
Comments
-
Hello Mollie,
You might consider creating a lookup table in sheet 1 with all of the data that you want to have populated, then using the LOOKUP function to populate the data that you need based on the email address/name of the person.
More information on LOOKUP can be found in the help center: https://help.smartsheet.com/function/lookup
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.5K Get Help
- 448 Global Discussions
- 144 Industry Talk
- 481 Announcements
- 5.1K Ideas & Feature Requests
- 85 Brandfolder
- 152 Just for fun
- 73 Community Job Board
- 492 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 304 Events
- 37 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!