Cell linking based on the cell value from the source sheet
Let's assume for a second that I have a file that is titled "Project Info". I also have a folder called "Projects". Every file in the project folder has the same columns though the project names are different. In Project Info, each filled row will have a unique key that references one of the files in Projects.
What I am trying to do is figure out how, if a line is added to the Project Info file, to automatically import that new line into another file that is determined based on the unique identifier.
It can be done in Excel, but is this possible on Smartsheet? Could I do it for a Sheet Summary?
Thank you for your help!