Welcome!

column restriction / assign task to multiple users

tanmoy.choudhury40516

Dear Team,

Can we restrict column for users and can we assign task to multiple people from the sheet.

Find more posts tagged with

Finance

Account and User Management

Comments

Chris McKay

Hi Tanmoy,

Yes, columns can be locked (by right-clicking and selecting Lock Column). You can also do the same for rows. Any locked columns cannot be edited by anyone unless they have Admin or Owner privileges.
Amazingly for a Project & Portfolio Management tool, you cannot assign multiple resources to one task. While you can add other Contact columns to a sheet, only one can be used to populate Resource View and truly be assigned to the task. This is one of the huge issues I have with Smartsheet.

Andrée Starå

Hi,

Yes, assigning multiple people to a task is now available.

Please see the attached link/screenshot for more information.

https://help.smartsheet.com/articles/518335-assigning-people-to-a-task

I hope this helps you!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Hi all,

We're pleased to announce that you can now quickly & easily assign tasks to multiple people. To do so, check the new "Allow multiple contacts per cell" checkbox in any contact column. The cells in that column will then allow up to 20 people to be added.

You can still leave that option unchecked when you only want a single person to be assigned to a task at a time.

Adding multiple contacts to a cell is useful not only for assigning people, but also for other scenarios where you want to associate multiple stakeholders with a row. For example, you might want those people to receive notifications when the row changes, or you may want them to appear in reports and filters.

For some projects, you may want to add 2 contact columns: one for the primary owner, and another for additional team members.

We welcome you to try it out and let us know what you think.

- Daniel

Bill Stadler

I was so happy to see this until I saw the limitation with it not showing in the card view. :-(

Sign in to join the conversation!

Quick Links

Trending discussions

Replace column of data from Excel snapshot
I had data deleted from a column in a tracking sheet. (2K+ rows) I pulled a snapshot from the activity log and I want to pull back the data from just the one column. I was told the right process was under File>Import>Update Rows, but I don't have that option under import. Is there another way to do this?
Copy Rows according to Multi-Dropdown
I have an Intake Sheet in which someone can select multiple Locations and multiple Fiscal Years that the Initiative will occur in. What I need is for this row to copy to the Retail Master Sheet a total of 6 times - one for every possible combination of the selected Location and Fiscal Year. DESIRED RESULT - My current…
I am receiving errorCode: 48 on one of my sheets
I am receiving errorCode: 48 on one of my sheets that is in a Workspace. All other sheets can be accessed except for the most important one. I have created 2 cases for this with no response from Smartsheet: Case# 08756481 Case# 08759594