Applies to
Smartsheet
- Business
- Enterprise
Capabilities
Who can use this capability
- Owner
- Admin
Assign people with an automation workflow
Add an email address or contact to a contact column in a sheet with specific triggers.
Who can use this?
Plans:
- Smartsheet
- Business
- Enterprise
Permissions:
- Owner
- Admin
Find out if this capability is included in Smartsheet Regions or Smartsheet Gov.
Follow these steps to assign people in an automated workflow:
- Go to Automation > Create from template...
- In the Sheet change section, select Assign someone when specified criteria are met > Use Template.
- Enter a name for your workflow.
- Configure what triggers the workflow.
- Select the contact column where you want to add the existing or new contact (defined as email address). You can use either a single-select or multiple-select contact column.
- Select Save.
Users with Editor-level permissions can only create, edit, or delete alerts or reminders with themselves as the recipient.
To know when assigning people:
- If a cell in a multi-contact column already has non-contact text (for example, not applicable or any other text that isn't a contact/email address) and overwriting is deactivated, the assign people action doesn't add a contact into the cell.
- Only 20 contacts per cell can be added. If a workflow constantly appends contacts to an existing cell, that cell may reach the limit and invalidate the workflow at that time.
- Contacts can only be added to contact columns.
- With the assign people action, you can only add email addresses or existing contacts that contain email addresses. The action doesn't currently support adding groups, Created By, or Modified By contacts.
- Assigning people is a terminal action. You aren't able to add conditions or actions after assigning people.
- Update cell actions need time to update the sheet, especially if there are multiple workflows.
To avoid creating endless loops, Smartsheet doesn't initiate the Assign people action when the trigger cell includes cross-sheet formulas or are linked to other cells. To work around this, use time-based automations or recurrence workflows.
Why am I receiving an error message from my workflow?
You may receive an error message in your workflow due to one of the following issues:
- The Assign people action’s Contact column is deleted, or changes to a non-contact type column.
- The Assign people action’s Contact column is changed from multi-contact to single-contact AND multiple contacts have been selected to be assigned.
- The Assign people action’s Contact column plus the number of contacts to be added during execution is greater than the max number of contacts (20).
- The Assign people action’s column is no longer write-capable (e.g., it’s a column formula).