return list from another sheet

Matt_w_questions

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)),"")

Shaine Greenwood

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