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?