Display date fields from two different sheets

Jeana
Jeana ✭✭✭✭✭✭

Hi,

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.

Thanks!

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!