Linking & Formulas

mhunt

I would like the information from the first document labeled template first to auto populate into the second smartsheet labeled template second. 

I am managing multiple projects at once and have 7 smartsheets to track the data specific to each of those projects. I have 1 master smartsheet which houses meeting information, administrative info and the pressing agenda items taken from the 7 different smart sheets.

What would be helpful is if I had a function in place that whenever I picked "admin" from the attention column the enter row item automatically populated to the template second sheet, creating a = relationship. 

Can you help  me with a formula to do this? 

Alejandra

Hi mhunt,

I don't have an example of a single formula you could utilize to accomplish this, but this level of automation can be done through DataMesh. If needed, more information on DataMesh can be found in our help article: https://help.smartsheet.com/articles/2476796-get-started-smartsheet-data-mesh