Can I combine 2 rows on a sheet?
I have a sheet with 2 separate forms. The first is completed when an injury occurs. A second form connected to the same sheet is completed after an action is taken. Is there a way to connect the two entries that are submitted at different times, but relate to the same incident?
Answers
-
Have you tried using update request for he 2nd part instead of using a form? Seem the info required on the action taken shouldn't be a lot. Update request to populate that action would be the best way to go, but you might have to set triggers as to when to send out the update request.
Forms generally create news when submitted.
Best regards,
Jacob A. PMP, AgileXP, CSM
Please kindly upvote if my contributions have provided you some value or answer. Thank you
-
Thank you for this. I was unaware of the update request option. I will look into that, but it seems like that will be a really good option for us.
Much appreciated.
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives