Linking & Formulas

06/28/19 Edited 12/09/19

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? 

Capture.JPG

Capture2.JPG

Comments

Sign In or Register to comment.