Create Report to Show rows that are blank

DieHard Jets

I want to create a report so that even rows with no data in them show up on the report.

For instance, let's say I have the name "Smith" and a name "Jones". On the main sheet I place a blank row between them to separate the names. But when I create a report and filter let's say on "Blank" and the Last Names no data comes up.

Kelly Moore

Hey @DieHard Jets

Do you have a Created date column, row ID column, or other system column that always contains data for every row, no matter what? You will need to bring this column into your report. You can hide this column in the report, but you need a column that actually contains data on every row. This will then allow you to see the skipped rows.

Kelly

DieHard Jets

Yes have all those columns. Let me give it a shot. Thanks.