How do I bring that report in to the destination sheet?

System

This discussion was created from comments split from: How do I populate a destination sheet with data from a source sheet based on a checkbox from source..

Gita Mooney

i have a similar question. I tried using Index and collect but one of the reference columns has multiple criteria and it breaks it. So I am trying using a report. I have the report. How do I bring that report in to the destination sheet? Also, if that works for currently existing columns, how do I make the same report work when new rows are added to the source sheet and I only want the new rows to be added to the destination sheet. Thanks in advance

Andrée Starå

https://community.smartsheet.com/discussion/comment/436889#Comment_436889

Hi,

I hope you're well and safe!

Can you elaborate and share some screenshots? (Please delete/replace any confidential/sensitive information before sharing.) That would make it easier to help.

I hope that helps!

Be safe, and have a fantastic week!

Best,

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

✅ Did my comment(s) help/answer your question or solve your problem? Please support the Community and me by marking it - Insightful 💡- Vote Up ⬆️ - Aweseome ❤️ - or/and as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!

Gita Mooney

I figured it out. when using Index(Collect()), i could not look for 2 values as a criteria for one reference field. So reverse engineered it and created a new column in my source sheet and made the rows that did not match my multiple criteria, blank and used the INDEX(COLLECT()) to pull in rows where the value is not "".

Cheers

Andrée Starå

https://community.smartsheet.com/discussion/comment/437352#Comment_437352

Glad you got it working!


✅ Please support the Community by marking your comment as the accepted answer. It will make it easier for others to find a solution or help to answer! I appreciate it, thanks!