Copy a specific field in sheet 1 to a specific field in sheet 2

MelM18

I have 2 SmartSheets - 1. My Project Plan and 2. My Communications Plan

I would like to copy specific fields from one sheet to another. For example, on my Project Plan I have a "Start Date" on row 177 that I would like to copy to "Admin Date" on row 1 of my Communication Plan.

The Project Plan dates change periodically and I'd like the Communications Plan to reflect the most recent information without having to manually populate it every time there is a change.

I played with vlookup, index, and match, but can't seem to get anything to work.

Any suggestions?

MelM18

This was answered in another post

The best method is a direct cell link.