How can I fill out columns in the sheet from another sheet?
Hi Team.
I am working on integrating data from 2 sheets. For instance, in sheet 1 we have Project ID, Resource Assignment, Time Allocation. In sheet 2, we have "Project ID", "Category", "Product Manager".
I would love to make a sheet including below information:
"Project ID"( sheet 1) , "Category Name, Product Manager" (sheet 2), and Time Allocation (Sheet 1)
It requires me to use functions such as excel function "XLOOKUP", but I couldn't modify any of these sheets beside using them.
So I would need a solution to integrate the information from 2 sheets. My assumption would be using Report, but in the report they can only simply add up rows.
Thanks in advance.
-Alice
Answers
-
I hope you're well and safe!
You'd need something unique to connect the records, and then you could use cross-sheet formulas combined with either a VLOOKUP or INDEX/MATCH structure to connect the sheets, and when you update the source sheet, it will reflect on the destination sheet.
Would that work/help?
I hope that helps!
Be safe and have a fantastic weekend!
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 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.
-
Thanks Andree,
Is that possible to link a grid with another grid? Just like what we do in the report setup.
Best,
-Alice
-
I am currently copy paste some static columns and use vlookup to retrieve the data from another sheet, the problem is that those columns are not next to each other, so it excess 100,000 cells according to the error pops up.
I need to match 2 condition to retrieve the target data.
Is there anyway / formula to fulfill this question? Thanks!
-Alice
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives