How to use data from another sheet as selection criteria?

Teddy

Hello, I am trying to build a Report or ANOTHER sheet where I pull data only for Rows from another sheet that have OrderNr=OrderNr from the other sheet. The ordernumbers change daily. I need to be able to refresh automatically on a daily basis. Any recommendations how I should approach this?

Mike Wilday

Reports will refresh automatically every time you open them. And it pulls the actual data from the sheet. See here more on creating reports. 

https://help.smartsheet.com/articles/522214-creating-reports