How can I update a row's information using a form?
I have a sheet that identifies each submission by a submission number. If I use that submission number as the "matcher" how can I update the other columns in that submission number row? I created a form but it only adds rows at the top. However, my coworkers will be using this and they won't have access to the sheet so I need an easy way for them to update the submission status and other columns related to that submission number.
Answers
-
@jhorvath Forms always insert new rows (you can control whether the row is at the top or the bottom.
For similar scenarios I have addressed, I usually create a report that shows the coworkers the information they need to see, and allows them to modify the specific columns.
The other approach is to use Update Request workflow, but your description doesn't make that seem suitable.
dm
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63.1K Get Help
- 380 Global Discussions
- 212 Industry Talk
- 444 Announcements
- 4.6K Ideas & Feature Requests
- 140 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 450 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 290 Events
- 35 Webinars
- 7.3K Forum Archives