Assign people to a task (2024)

In Smartsheet, you can use the Contact List column type to assign tasks to team members.


  • Smartsheet
  • Pro
  • Business
  • Enterprise

For more information about plan types and included capabilities, see the Smartsheet Plans page.

Set upa contact list column for assignment

To assign people to tasks on your sheet, the sheet must containa Contact List column. If it doesn't Contact List column, you can insert one using the following steps:

  1. Right click on any column name and select Insert Column Right or Insert Column Left.
  2. The New Column window appears.
  3. Type the name of the column in the Name box (for example, type "Assigned To").
  4. Select the Contact List column type.

    If you have tasks that need to be assigned to multiple people, checkAllow multiple contacts per cell.

    In the mobile application, you'll be able to add one or more contacts to a Contact List column depending on which option was set on the web application; however, you can't set this option from the mobile app.

    To make certain people easier to add to contact cells in the sheet, you can type a list of preferred contactsinto theAdd Contacts box —the people that you specify here will appear when you click the dropdown arrow in a cell.

  5. Click OK.

That's it! The Contact List column is inserted into your sheet. Now you can assign people to tasks.

  • You can create filters or build reports to see all of the tasks assigned to specific team members. Learn more aboutviewing your assigned tasks.
  • Insert multiple Contact List columns when people have different roles related to each task.
  • You can build alerts to automatically send notifications and requests to people who are assigned to tasks. Learn how toautomate your work with alerts and actions.
  • As long as a Contact List field isn't being used for resource management, you can build a formula which automatically assigns people to tasks based on conditions. For example, assign a department head to a task that needs their approval with an INDEX and MATCHformula. Learn how tocreate and edit formulas in Smartsheetand create formula combinations for cross sheet references.
  • You can also use workflows to add contacts to a cell automatically. Learn how toassign people in an automated workflow.

Assign tasks to multiple people

If you want multiple people to work on a task, set up your Contact List column to Allow multiple contacts per cell.

Once the column is set up, type the name of an existing contact into a cell to display a list of matching contacts then select the desired contact to add them to the list of contacts assigned to the task.

Keep the following in mind when working with multiple contacts in a cell:

  • Each contact must be associated with an email address. If you enter the name of a new contact into a cell, you’ll be prompted to enter their email address as well.
  • You can add up to 20 contacts per cell.
  • Columns with multiple contacts cannot be used for grouping in a report. Learn more aboutconfiguringgrouping to organize results in report builder.

You can use capacity view to identify over or under-resourced allocation across your organization, spot availability to take on new work, and forecast hiring needs to make efficient staffing decisions.

Restrict assignment to a single contact

When a task should only be assigned to one person, restrict the Contact Column to a single contact by leaving Allow multiple contacts per cell unchecked. For example, with an Approval Request, you'll want to ensure that only one person, such as the manager, approves each step in the process to ensure multiple contacts do not overwrite each other's approvals.

  • With a Single Contact column, you can use your preferred contact list to group tasks by assignee if you switch to Card View.Learn more aboutcard view.
  • Single Contact Columns can also be used for grouping in a report.
  • You can add multiple Contact Columns when people work on different parts of each task.

Manage which contacts appear when you typein a cell

When you type a name or email address in a Contact List column, the names that are displayed will include the following:

  • Any preferred contact values that you’ve set upin theColumn Properties window.
  • All collaborators shared to the sheet.
  • Any other contacts or email addresses that have been assigned to other rows in the sheet.
  • People in your personal Smartsheet contacts list.
  • If your account is part ofa Business or Enterprise plan, and other people that are in the plan. Learn more aboutUser Management.

Add contacts to the autosuggest picker

If you start typing a name or email address and aren't seeing the contact list autosuggest, then your contact list doesn't include a contact matching what you've typed. To add them to your Contact List column, click the dropdown arrow in the cell then select Add New to add the contactname and email address to your list and assign them to the row. You can also edit the column properties to add them to the preferred contact values.

Remove duplicate contacts from the contact list

You will occasionally see duplicate contacts when you typea name or email address into a cell. To remove names or email addresses from the contact list, remove them from the preferred contact values and other cells in the column.

If you still see duplicate contact values, it’s possible the name you’ve set up for the contact in your personal Smartsheet Contacts does not match the name they’ve associated with their Personal Profile. See manage contacts in the my Smartsheet contacts list and manage your personal profile to ensure the name in your contacts matches the name on their profile.

You won’t be able to remove shared collaborators from the contact list.

Assign people to a task (2024)
Top Articles
Latest Posts
Article information

Author: Dr. Pierre Goyette

Last Updated:

Views: 6096

Rating: 5 / 5 (50 voted)

Reviews: 89% of readers found this page helpful

Author information

Name: Dr. Pierre Goyette

Birthday: 1998-01-29

Address: Apt. 611 3357 Yong Plain, West Audra, IL 70053

Phone: +5819954278378

Job: Construction Director

Hobby: Embroidery, Creative writing, Shopping, Driving, Stand-up comedy, Coffee roasting, Scrapbooking

Introduction: My name is Dr. Pierre Goyette, I am a enchanting, powerful, jolly, rich, graceful, colorful, zany person who loves writing and wants to share my knowledge and understanding with you.