Formula to copy contents of a sheet to another

Vicky.Malhotra

I’m new to smartsheet and am trying to figure out a way to call contents of a sheet to another based on certain criteria, something similar to what Filter function does in google sheets.

I am aware that I could achieve this using the index collect function, however the data I am trying to call goes in hundreds of rows. Any ideas on how this can be done?

Andrée Starå

Hi @Vicky.Malhotra

I hope you're well and safe!

Have you explored using the Premium App, DataMesh?

Is that an option?

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, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!