Linking & Formulas

edited 12/09/19 in Formulas and Functions

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? 




Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!