Archived 2017 Posts
Archived 2017 Posts
Welcome to the Smartsheet Forum Archives
The posts in this forum are no longer monitored for accuracy and their content may no longer be current. If there's a discussion here that interests you and you'd like to find (or create) a more current version, please Visit the Current Forums.
Forms and formulas
Hello,
I am new to Smartsheets and am creating a form to send out and collect orders from customers. Now the form works but I need it to populate the new rows that get added with pricing from another sheet. Is this possible as I am not finding any info on this but then again I am new to the site. I would also like to know how to email the total amount back to the customers email address for them to keep a record of. Any help would be greatly appreciated.
Thanks
Eric
Comments
-
Hello Eric,
You can do this by creating cell links from your pricing sheet to your sheet with the form. Currently, this is a manual process; details on cell links are available here: https://help.smartsheet.com/articles/861579-cell-linking
You can then email the rows out to people with an automated change notification based on the linked cell data. More info on creating automatic notifications can be found here: https://help.smartsheet.com/articles/542904-using-notifications
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 67.8K Get Help
- 474 Global Discussions
- 207 Use Cases
- 517 Announcements
- 5.5K Ideas & Feature Requests
- 87 Brandfolder
- 157 Just for fun
- 83 Community Job Board
- 521 Show & Tell
- 36 Member Spotlight
- 3 SmartStories
- 309 Events
- 37 Webinars
- 7.3K Forum Archives