How Can I Pull only row data based on a specific cell in the row meeting certain conditions
In Excel I am able to use the below formula to pull row information into another sheet so that the only rows that are pulled meet the criteria of 1 conditon.
=IFERROR(INDEX('On Rent'!$A:$A,SMALL(IF(AM$1='On Rent'!$B:$B,ROW('On Rent'!$A:$A)-MIN(ROW('On Rent'!$B:$B))+1,""), ROW()-1)),"")
I am looking for a way to do this in smart sheet by pulling form one sheet to another. i.e. If my "On Rent" Sheet column A has 3 different rental contract numbers and I want in a new sheet to pull only the rental contract number 12345 and populate any data I want from only those rows that are 12345