Sign in to join the conversation:
The posts in this section are historical and no longer monitored for accuracy. If this discussion interests you and you'd like to join in, please visit the active Community to post and engage.
Is there a formula or reference for an assigned to column that would automatically be the sheet owner? I'm trying to setup an automatic reminder email to a sheet's owner two weeks before a milestone date.
Gordon,
You'll need to set up the Reminder for each sheet, and it won't change if the sheet owner changes.
http://help.smartsheet.com/customer/en/portal/articles/542913-using-reminders
Though that would be pretty neat.
Or if there was a way in your account to define a role (ie Head of HR) and if a new person takes that position, there would not be a lot of effort spent to update the emails.
Craig
Craig is correct, just set a sheet level reminder from the Alerts tab that sends the sheet owner (select the name manually) and email two weeks before the milestone date (select the column).
