How to pull avature application date from another sheet
Hello,
I am stuck coming up with collecting avature application dates from another sheet.
The full name is the column that I want to use from other sheet to pull the avature application date over.
Below is the sheet where avature application date is:
Answers
-
You will have to setup cross sheet references for both column in your source sheet.
=IFERROR(INDEX({Avature Application}, MATCH([Full Name]@row, {Full Name}, 0)),"")
-
I put this in the master directory sheet but does it need to be something saying to pull from the hired sheet to pull the avature application date?
-
I tried adding:
=IFERROR(INDEX({{Hired Range 1}, MATCH([Full Name]@row, {Full Name}, 0)), "")
but nothing came back
-
Here is the article on cross sheet references. Anytime you reference a column from another sheet, you must setup a reference to specify where to look.
https://help.smartsheet.com/articles/2482644-create-cross-sheet-references
-
Hi @Louis.Smith
I hope you're well and safe!
Try something like this.
=IFERROR(INDEX({Hired Range 1}, MATCH([Full Name]@row, {Full Name}, 0)), "")
Did that work/help?
I hope that helps!
Be safe, and have a fantastic week!
Best,
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
-
Thank you,
The cells that it pulled is blank.
I don't see an error code or anything, just a blank cell
-
Try this and let us know what error message you get.
=INDEX({Hired Range 1}, MATCH([Full Name]@row, {Full Name}, 0)
SMARTSHEET EXPERT CONSULTANT & PARTNER
Andrée Starå | Workflow Consultant / CEO @ WORK BOLD
W: www.workbold.com | E:andree@workbold.com | P: +46 (0) - 72 - 510 99 35
Feel free to contact me for help with Smartsheet, integrations, general workflow advice, or anything else.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 65.9K Get Help
- 429 Global Discussions
- 147 Industry Talk
- 487 Announcements
- 5.2K Ideas & Feature Requests
- 86 Brandfolder
- 151 Just for fun
- 74 Community Job Board
- 497 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 305 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!