Smarter Report Filters

Tim_Simmons

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).