Using Multiple Forms to Update a Single Row
Is there a way to use multiple forms to feed into a single row?
An example would be our orthopedics program. Our coordinator collects several pieces of information from multiple departments (OR, Pre-Surgical, Med/Surg Nursing Floor, Education, etc.)
Can I build something so she can create a row per patient with their ID number and have others use a form to fill in their specific pieces, but everyone's information would be housed on the same row linked to the original patient ID number?
Thanks!
Regina
Answers
-
You would need to use either an Update Request so that the info populates the same row directly, or you would need a separate sheet with the forms and use formulas with cross sheet references to the form sheet on a "summary" sheet to gather all of the data.
Come see me in Seattle at ENGAGE 2024! I will be at the 10xViz partner booth throughout as well as the "Lets Talk About Community" Meet & Eat table on Tuesday from 11:45am - 12:45pm!
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 379 Global Discussions
- 212 Industry Talk
- 442 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 304 Events
- 34 Webinars
- 7.3K Forum Archives