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?
Comments
-
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
Help Article Resources
Categories
Want to practice working with formulas directly in Smartsheet?
Check out the Formula Handbook template!
Check out the Formula Handbook template!