Report Error

Ashlee D

Hello, 

 

I am trying to create a report that brings in multiple date types so that I can use the calendar view to see my marketing and PR activity. I created a marketing campaign tracker and PR campaign tracker. The marketing campaign tracker has a launch date and end date and the PR tracker only had one date. I tried to pull all the info together but it wasn't appearing so I tried adding an end date to the PR campaign to see if it would collect this data but it still isn't working. I named the Marketing campaign dates Launch Date and End Date, but the PR tracker header only says Date, is this the issue? Do the headers have to be the same, even though I am adding extra columns? I can create a report asking for the Launch Date, End Date and Date, no data shows? Do the headers have to have the same name?

Brent Nathan

Make sure all of your date columns in each sheet have exactly the same name, and are both set as "date" type columns.  This should funnel both columns into a single report properly.