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.
Alerts to non-shared resources
We are trying to implement an editorial calendar.
Smartsheet works great for this in theory.. ie: we have the primary row as an calculation that shows us: "Client (Content Type) Title (Creator name)" - perfect. this is awesome.
We have the due date as the calendar date. - Again.. perfect.
HERE IS THE CHALLENGE
We have writers/content creators who CANNOT have access to the entire sheet. In fact, I don't want them to access the sheet at all.
I've created a field for their name (Creator name) and a (Creator email) field.
I want an alert that goes out 3 days prior to (Due date), 1 day prior to (Due date), and on (Due date) to any (Creator email).
Otherwise, this is a manual process.. which is painful.
In the idea scenario, these would be "row update" requests. And if a content creator has multiple items due, they'd receive a single email.