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.
Project Management
Hi, we currently have a few web forms, that allow clients to request quotes. These then populate fields on a smartsheet as normal. We have two challenges that I'd like to implement but can't seem to get it right.
We would like to give the client more visibility on the status of the opportunities, but for various reasons, do not want to share the working sheet.
We are struggling to keep up to date on the various opportunities as the makeup of this smartsheet doesn't give us enough information or have the correct fields.
Is it possible to have the information on one sheet mirror with a second sheet? We can then give the client access to that sheet, but restrict what info is mirrored
From a project perspective, we would like the original information to populate as it does, but then each line to start a new smart sheet as well. With this new sheet having various lines linked to the master sheet, but also have additional fields that are 'in-house'?
Any ideas?
Comments
-
Hi David,
You might consider creating a report and then publishing it. This would allow you keep your contacts updated without exposing the entire sheet to them. It's also read-only so they can't edit the published report: https://help.smartsheet.com/articles/522078-publishing-smartsheet-items
Another way you can do this is by creating notification rules that will notify specific people based on certain criteria. Details on this here: https://help.smartsheet.com/articles/542904-using-notifications
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 64.2K Get Help
- 419 Global Discussions
- 221 Industry Talk
- 461 Announcements
- 4.8K Ideas & Feature Requests
- 143 Brandfolder
- 141 Just for fun
- 58 Community Job Board
- 462 Show & Tell
- 32 Member Spotlight
- 1 SmartStories
- 299 Events
- 38 Webinars
- 7.3K Forum Archives