-
Toolbar Inconsistencies
I have created a "Master Sheet" that I have to import each day and have linked up other tabs/sheet to that Master Sheet to filter out on the information my technicians need to see. On the Master Sheet I have the full options on the toolbar, but on the linked tabs/sheet there are hardly any options. For example, my…
-
Conditional Weighted Averages
Hello, I want to use the AVGW function to get the weighted average of the column "Cost" against the column "Probability of Cost" but only if the column "Status" is Approved. The column "Status" can also be Pending. The function SUMIFS works great if you don't need to do the weighted average. Is there a preset function or…
-
How Smartsheet define, handle and monitor allocation on teammember
Hi fellow Smartsheeteers, I encounter another challenging scenario that some of you have encountered and find a solution to it. Here is the scenario: I have task as an individual and also have task as a team member. Example of task that involves team are doc reviews with a group of people. I have numerous scenarios: 1)…
-
Project Team Resource Allocation
Hi, Can anyone share how they're tracking their teams resources? The resource allocation is great however, it only allows me to show one team member not multiple per task. In addition, I'd need this information for executive reporting to support my teams concerns of being over allocated across projects. Thanks!
-
Assigning people to Tasks
Hi, Can you tell me if it is possible to assign multiple people to one task (one column) at the moment I can only assign 1. Thanks.
-
Assigning multiple resource to a single task
Proposed solution: to create "dummy" tasks in case multiple resource are assigned to a single tasks, sounds very amateurish for a great professional product like Smartsheet. Are there any plans to add ability to assign multiple resources to a single tasls like MS Project?
-
Multiple Resources?
I think I found my answer, but I have a need to assign multiple resources to a single line (an event) within a sheet. We manage marketing tours associated with multiple drivers and multiple vehicles. In some cases, a single tour (or single event for that matter) might consist of 3-4 drivers and 3-4 trucks. When scheduling…
-
Assign a task to more than one person?
Is there a way to assign more than one person to a task without having to create a whole new separate row or splitting the task into multiple tasks? It seems a bit messy to do so if I have a lot of tasks that will need multiple resources.
-
Multiple people assigned to one task
If I have multiple people assigned to a task, could I create two "assigned to" columns (each with a slightly different name) and still use the notifications and reminders without issue? That would prevent me from having to create two duplicate tasks when I want to assign to multiple parties.
-
Why can we still not assign multiple resources to a task?
How in the world is there still not a way to assign multiple team members to a single task? This is such an essential feature to my company (and I would imagine many others), that not having it available basically makes Smartsheets useless for us. It certainly makes the resource allocation tool useless, and that is really…