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
- 62.4K Get Help
- 364 Global Discussions
- 202 Industry Talk
- 430 Announcements
- 4.4K Ideas & Feature Requests
- 137 Brandfolder
- 129 Just for fun
- 128 Community Job Board
- 446 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 284 Events
- 35 Webinars
- 7.3K Forum Archives