Automatic Data Dragging

Hi Community,

I am looking for a formula that can help me to pull data from one smartsheet to another.

First thing that came in my mind was the VLOOKUP, but in this case it is not sufficient.

The formula should pull the all the rows (complete row) from another smartsheet, but only if the budget impact (multiple columns) is higher than 0.

Does anyone know how to do that properly within smartsheet?

Thanks for your help!



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!