How to Limit Access to Smartsheet
I know this question likely goes against all that is Smartsheet, but...
We have a sheet setup to take submissions from a form. When a new row is added, a contact in a column is notified. After the row's status is still "in progress" for 3, 6, and 9 days, the contacts get reminders that these rows are still "unresolved" and that they need to contact the Chief of Staff (CoS) to mark the issue resolved.
Here is the problem; when the Reminders go out, they contain a link to the Smartsheet -- the CoS only wants them to get a reminder -- not access the Smartsheet (because some of the information may be sensitive).
What is the best way to set this up -- we want them to get the information from the row submitted where they are the contact, but we don't want them accessing the Smartsheet.
Is this even possible?
Help Article Resources
Check out the Formula Handbook template!