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
Check out the Formula Handbook template!
