Can I take a cell value from a reference sheet and update the source sheet with the value?
I have a "database sheet" of assets in our company. I also have a "Scan sheet" that consists on 1 field that is used to scan a qr code and return the scan code in that cell. There are then 9 rows that index collect to the "database sheet" to show the asset information. What I am trying to do is be able to assign that asset to a new contact in the "scan sheet" and have that reflect back to the "database sheet". (still having the ability to re assign contacts in the database sheet) Having trouble thinking through to the right solution, any help is greatly appreciated.
Answers
-
I believe this could be achieved using a combination of a workflow to copy rows over to your "Data base" from your scan sheet. Then use a formula to flag the old information for removal via Workflow to move to another "Trash" sheet. Thus leaving only the copied Row as the current data.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
-
This was actually the solution that we tested. While it did work it was clunky and slow since everything was based on automations. I think our long term answer here is going to be bridge. We are configuring a prototype now. I appreciate your response and insight on this. @Mark.poole
-
Of Course. I know its a bit clunky. I am glad you all found a work around that better works for your situation.
If you found this comment helpful. Please respond with any of the buttons below. Awesome🖤, Insightful💡, Upvote⬆️, or accepted answer. Not only will this help others searching for the same answer, but help me as well. Thank you.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 63K Get Help
- 380 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
- 305 Events
- 34 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!