How to pull in row data from Sheet 1 into Sheet 2 if two criteria are met
Answers
-
Hi @Jessica d, that depends on what you mean by "pull in row data" -- are you looking to transfer an entire row? You can do that via either an automation or DataMesh (if you have the correct license). An automation would require that all your columns in your source sheet have corresponding columns in your destination sheet with matching column names. DataMesh is more flexible.
If you just want pull data from one cell to another cell, say from Column B in your source sheet, then you would use this formula in your destination sheet:
=INDEX(COLLECT({Column B}, {Column A}, 1, {Team}, "TeamName"),1)
Feel free to expand a little on what you're looking for.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 305 Events
- 34 Webinars
- 7.3K Forum Archives