-
Notification of Assignee when predecessor is 75% complete
All My project team members want to have "look ahead " insight into tasks they have upcoming. Is there a way to notify the assignee of the successor task when the predecessor is 75% complete, or x number of days from completion. Currently they receive the notification the day the task is to start. Any suggestions are…
-
Configure Form
* How to configure the selection of two or more options within a single question.
-
Shortcut button of sorts for a Project template
I have many projects in a Project Management workspace. The project sheets have a section to order materials for projects. I have a GRID Sheet in another section of Smartsheets that creates purchase order numbers and has a brief description of materials ordered. I would like a shortcut on each project sheet that would…
-
Nested IF/AND formula
I am new to smartsheets and I am having a hard time with a formula, hopefully someone can help me. I am trying to create a formula that will indicate the status of a task based on the following condition: * whether the task is completed or action is required * whether the task is at risk or not To conclude this is what I…
-
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?