Report criteria based on two sheets, matched on row

Therese Campbell

Is it possible to create a report based on data from two sheets, but criteria is include only rows where the entry in primary column in one sheet is identical to the entry in its counterpart column in the other sheet? In other words, matched on rows? I don't see where to set this in the report builder.

Andrée Starå

Hi Therese,

Unfortunately, it's not possible at the moment, but it's a great idea!

Please submit an Enhancement Request when you have a moment.

A possible workaround would be to have a formula check if the primary columns are identical and then check a checkbox or similar and use that as a criterion in the report.

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? That would make it easier to help. (Share it to: andree@getdone.se)

Would that work?

Have a fantastic weekend!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

Hi Therese,

How did it go? Did you manage to get something set up?

Happy Holidays & Happy New Year!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting