return list from another sheet
Anyone able to offer some help on the formula below - trying to return a list of information relative to an employee ID number to a column. There will be several matches per ID, e.g. Matt worked item 1.. 2... 3.. and 7. I want to return the information relative to that ID for those entries.
Thanks in advance!
=IFERROR(INDEX({Phone TESI Data Tracker - 1 Assigned Items Range 1},SMALL(IF([working column - do not modify]1={Phone TESI Data Tracker - 1 Assigned Items Range 1},ROW{Phone TESI Data Tracker - 1 Assigned Items Range 1}({Phone TESI Data Tracker - 1 Assigned Items Range 1})-2,""), ROW{Phone TESI Data Tracker - 1 Assigned Items Range 2},2)),"")
Comments
-
Hi Matt,
It appears that you're trying to use a ROW function, which doesn't exist in Smartsheet. You can review our complete list of functions here: https://help.smartsheet.com/functions
You may also be interested in the @cell and @row parameters: https://help.smartsheet.com/articles/2476491-create-efficient-formulas-with-at-cell
You might also consider creating a formula with the INDEX and MATCH functions to supplement what you're wanting to do with ROW. Here's a community post with information on their implementation: https://community.smartsheet.com/discussion/how-index-match-multiple-criteria
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!