Linking Data between Sheets

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?

Matt Lynn#

The best method is a direct cell link.

Matt Lynn#

The best method is a direct cell link.

MelM18

Duh! I knew there was a really easy way and totally overlooked that little icon. Thanks for responding so quickly!!