Forms and Overwriting only Cells
I have a form for Safety Credentials which feeds into my Source Sheet.
When the user fills out the form, they may only put in one credential.
If the user previously put in a credential it creates a new row and updates the pertinent cells in a Destination sheet. All of this works great.
My concern is that there are only 20,000 rows allowed in the Source Sheet.
If a user row is kicked off because the limit is reached, and the user row has a still valid credential in one of the cells, then that credential will disappear in the Destination sheet.
Is there any way for me to combine new cell information from the form with existing users?
I am attaching the Source Sheet as a screenshot. You can see the Safety Credentials that are filled in with the form. But one user may fill out only one credential each time.
Answers
-
Have you looked into Update Requests?
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
- 62.9K Get Help
- 379 Global Discussions
- 210 Industry Talk
- 441 Announcements
- 4.5K Ideas & Feature Requests
- 139 Brandfolder
- 129 Just for fun
- 130 Community Job Board
- 449 Show & Tell
- 30 Member Spotlight
- 1 SmartStories
- 300 Events
- 33 Webinars
- 7.3K Forum Archives