Help with report filter from multiple sheets

AmandaHore

I have a report that is from two different sheets.

There are 3 columns that are the same in both sheets. In one of the sheets there are also 5 additional columns.

Sheet 1 has Name, Date, Location

Sheet 2 has Name, Date, Location, End Date, Xtra field 1, Xtra field 2 etc

The report combining the data works well.

I only want to show data on the report where:

If the end date is not blank, and the end date is in the future

If the end date is blank, and the date is in the future.

When I apply this filter, only the data from sheet 2 shows. Any data for sheet 1 no longer shows as it does not have an end date field.

is there a way to do this without creating an end date field in sheet 1 that is hidden and never gets populated?

Michelle Choate 2

No. If there is no End Date column to filter against, it just filters out all of the data.

AmandaHore

ok thank you - I will add the field in and then hide it.