Can anyone help with a report issue?

Tina Conrad

I have a report based on multiple sheets. I have a filter that is a field on all sheets. For some reason, some sheets are not included on my report. Everything looks fine. What can I do?

MCorbin

Check your Columns list.... Is that one field listed multiple times? If so, then there's a difference between your sheets in that column - could be a slight spelling difference or column type. All the columns need to be identical in order to work together in a report.

That's usually what I find when a report is acting goofy...

Andrée Starå

Hi @Tina Conrad

I hope you're well and safe!

Can you describe your process in more detail and maybe share the sheet(s)/copies of the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, andree@workbold.com)

I hope that helps!

Be safe and have a fantastic week!

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!

MCorbin

Check your Columns list.... Is that one field listed multiple times? If so, then there's a difference between your sheets in that column - could be a slight spelling difference or column type. All the columns need to be identical in order to work together in a report.

That's usually what I find when a report is acting goofy...

Tina Conrad

Thank you. There were two columns with the same name. I found that the column properties were different. It is now fixed!

Have a wonderful holiday weekend!

Andrée Starå

@Tina Conrad

Happy to help!

Glad you got it working!