Can I dynamically update data from a single column into another sheet to reflect added rows ?

@Paul Newcome - Are you able to assist me in walking through linking a data column from a roster sheet to a project sheet? I have a site roster that can change on occasion (new sites added) and I want to add only the Primary Column name into a project sheet to show this new site as needing to be added to the project.

I already linked the initial locations via basic cell linking but because you can't cell link blank cells I need a formula that will populate new sites to my project sheet as they are added to the site roster.

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!