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.
Answers
-
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
-
Yes have all those columns. Let me give it a shot. Thanks.
