Smarter Report Filters
Could filters within the report builder be smarter?
As an idea, could Smartsheet incorporate the "@row" reference as an option to make some of the filters smarter e.g.
Column A has a figure, Column B has a figure. You are looking to create a report, however exclude any rows where Column A equals Column B (or doesn't equal).
So when using the Report Builder you would:
select the field to be "Column A"
select the type to be one of "greater than", "Less than", "Between" etc.
Within the value field, use an @row reference e.g. "[Column B]@row"
I know that this can be done by creating a column within the reference sheets of the report and using an "if" function to create a true / false value that you can then filter on through the report builder, however the above would allow some additional flexability that doesn't require retroactively creating columns, especially in blueprint generated sheets (I know that you can also easily use the Control Centre to add new columns etc).
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 465 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives