How can I keep specific rows from showing on a report?
I need to find a way to keep specific rows from showing up on a report. How can i do that?
Best Answer
-
Hi @Dawn Killien ,
The easiest way is to find a data field in that row(s) that doesn't have the same value as any row you want reported. Add a criteria to the report builder that excludes that value. If there isn't a unique data field/value, you can add a helper column; another coulm that lets you flag the rows you don't want reported. Does that help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
Answers
-
Hi @Dawn Killien ,
The easiest way is to find a data field in that row(s) that doesn't have the same value as any row you want reported. Add a criteria to the report builder that excludes that value. If there isn't a unique data field/value, you can add a helper column; another coulm that lets you flag the rows you don't want reported. Does that help?
Mark
I'm grateful for your "Vote Up" or "Insightful". Thank you for contributing to the Community.
-
I added a helper column and it worked perfectly.
Thanks!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64K Get Help
- 410 Global Discussions
- 220 Industry Talk
- 459 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 137 Just for fun
- 57 Community Job Board
- 459 Show & Tell
- 31 Member Spotlight
- 1 SmartStories
- 298 Events
- 37 Webinars
- 7.3K Forum Archives