Combining Two Sheets into a Report

latsyrcg3 ✭✭✭
edited 12/09/19 in Smartsheet Basics

I have two task lists with slightly different columns, but there are some overlap - like status, completion date, & targeted completion date. I would like to run a report or some how combine all the tasks into one report/view/sheet - while continuing to maintain the two task list as separate sheets. I tried to create a report with two sources, but it didn't work (when I create a report for each sheet separately, it works). I assume that it isn't working because the columns aren't exactly the same - but then what is the point of a report?