Linking & Formulas
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?
Comments
-
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
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- 10.7K Get Help
- 63 Global Discussions
- 69 Industry Talk
- 385 Announcements
- 3.5K Ideas & Feature Requests
- 55 Brandfolder
- 125 Just for fun
- 50 Community Job Board
- 464 Show & Tell
- 40 Member Spotlight
- 44 Power Your Process
- 28 Sponsor X
- 234 Events
- 7.3K Forum Archives
Check out the Formula Handbook template!