Automatic Data Dragging

Ansson

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!

Andrée Starå

Hi @Ansson

I hope you're well and safe!

You'd use a combination of INDEX/COLLECT for that.

https://help.smartsheet.com/function/index

https://help.smartsheet.com/function/collect

Make sense?

Did that work/help?

Also, have you explored using a Report instead?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Ansson

Hi @Andrée Starå thank you very much, that already helps a lot!

Just one more question: How do I then extract the whole row and not only one cell?