DataMesh from Report Still Pulling Filtered Rows
I have a DataMesh that is meant to pull rows from a report that excludes rows with certain criteria. Unfortunately the DM seems to pull all of the rows from the report and ignores the report's filter. Anyone else experiencing this or found a solution?
Best Answer
-
I figured it out. The filter has to be applied to one of the columns selected in the DataMesh. If I apply a filter on a different column, DataMesh will still copy over filtered rows even though the rows don't appear on the report.
Answers
-
Hi Jacob,
Could you provide screenshots of the Report, DM filter settings?
Gia Thinh Technology - Smartsheet Solution Partner.
Email : thinh.huynh@giathinh.tech -
I figured it out. The filter has to be applied to one of the columns selected in the DataMesh. If I apply a filter on a different column, DataMesh will still copy over filtered rows even though the rows don't appear on the report.
-
Hi Jacob, Thank you for sharing your findings.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 66.7K Get Help
- 438 Global Discussions
- 152 Industry Talk
- 497 Announcements
- 5.3K Ideas & Feature Requests
- 85 Brandfolder
- 155 Just for fun
- 77 Community Job Board
- 509 Show & Tell
- 34 Member Spotlight
- 2 SmartStories
- 307 Events
- 36 Webinars
- 7.3K Forum Archives
Trending Posts
- I want to use Power Automate to send a professionally formatted email with Smartsheet data embedded in it. For example, Power Automate would receive the person's name, email, and pre-filled form's lin…
- Hello! Happy Friday! 😀 I am currently working on creating a Supply Request Tracker that will allow the requestor to upload their excel file with the list of needed supplies to a Smartsheet form conne…
- I setup a new Smartsheet and am connecting it to Jira Cloud. All fields are syncing properly except the Team field. I have the column set up as text number but have also tried it as a Drop Down list. …
