How to change cell information using a Form
I have a sheet that the first row filled in using a form (Intake). At some point data in one column may change. I need to create form that will modify the cell content of row 1 to a new contact but leave all of the other data in place.
Anyone have an idea on how to accomplish this?
I have tried creating a form but all that does is add a new row. While that would work the individual that would complete the change form does not have access to see all of the other Meta data. So would not know who to assign in the other fields.
Best Answer
-
You'll need to manually push or set up an automation that issues an update request to whomever you're seeking the data from. You can make these triggered in automations as needed. You can also manage the viewable data in a recurring automation template.
Forms always only create a new row. They can not be used otherwise.
Answers
-
You'll need to manually push or set up an automation that issues an update request to whomever you're seeking the data from. You can make these triggered in automations as needed. You can also manage the viewable data in a recurring automation template.
Forms always only create a new row. They can not be used otherwise.
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.8K Get Help
- 376 Global Discussions
- 207 Industry Talk
- 440 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 284 Events
- 33 Webinars
- 7.3K Forum Archives