Display date fields from two different sheets
I'm tracking an estimated Start and End date (in a Project Sheet) and an Actual Start and End date (in a tracking sheet). In both sheets the rows where the dates are entered are CHILDREN and they both have an Asset # that I'm can match them to each other with.
I'm looking for a way to display both the Project Sheets estimated Start and End dates along side of the Actual Star and End dates, either in a report or by pulling the Actuals into the Project sheet.
I've tried a report, INDEX MATCH and even DATA MESH with no results. I'm confounded why the cells keep coming back blank or INVALID.
I'd appreciate another pair of eyes on this. I don't think it's that hard but I'm clearly missing something.
Help Article Resources
Check out the Formula Handbook template!