faster way to load report criteria?

Tanya Brooks

Currently rsetting criteria for a report takes a minuimum of 5 clicks (what, select field, select criteria, select expression, save). I need to run a report showing 20 columns and expression for all 20 is "is blank." Is there a way to select all the field data at once and set criteria afterward?

Andrée Starå

Hi @Tanya Brooks

Unfortunately, as far as I know, it's not possible at the moment, but it's an excellent idea!

Please submit an Enhancement Request when you have a moment

As a possible workaround, you could add helper columns to check the sheet(s) criteria instead and then use that in the Report Builder.

Make sense?

Would that work/help?

I hope that helps!

Be safe and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Tanya Brooks

"As a possible workaround, you could add helper columns to check the sheet(s) criteria instead and then use that in the Report Builder."

I don't know how to add helper columns. Can someone help? Tanya

Andrée Starå

@Tanya Brooks

Helper Columns are just a name for columns that only function to help with something like criteria that isn't available in the Report Builder.

You'd create checkbox columns as needed and then add a formula that would check a box if true and then reference that in the Report Builder.

Make sense?

Would that work?