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
Answers
-
Have you looked into creating a row report?
-
@smithaa Have you tried creating a workflow within the source sheet to copy the rows over to your second sheet? You can set condition paths to ensure that only the rows that match your requirements are copied over to the new sheet.
Tip: When using this approach I always create a helper column with Checkbox data-type to have this box checked by the same workflow after it runs to avoid having the same row copied over to the second sheet multiple times.
If you need to do this on a recurring basis for the same row, you will need to use the Auto-Number rows duplicate check column.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives