Resource Management

Archives for August 2023

How to make the value of “Duration” field be updated automatically when I change the assignees.
Hello SmartSheet Team, How to make the value of “Duration” field be updated automatically when I change the assignees. For example, there is one task effort is 8 person days, if I assign two members as the processors for this task, I suppose the “Duration” should be 4 person days automatically. But the value of “Duration”…
Editing Start & End Date w/dependencies enabled
I have a worksheet with a Start & End and Project Settings set. I really need the durations and predecessors for the Gantt chart. However, I want my users, ELT, to work only from a report of Dynamic View and they need the ability to edit their dates as needed. According to the article below you can only edit the dates in…
Reminders: How to set up reminder if cell DOESN'T change?
I want to set up reminders, and force and escalation, if a Status cell does not change after X days. Scenario: Someone fills out an intake form. The Status is "Not Started" by default at the time the Intake form is submitted. The team's SLA is 3 days to change the status to "Reviewed" or "In Progress." If they don't, I…
Approving time entered in advance
*** EDIT THIS HAS BEEN CONFIRMED*** I'm relatively new to RM Timesheets. I wanted to confirm that you can't approve time entered in advance. As an example, someone has submitted her timesheet for this week, but has noticed she can only approve Monday and Tuesday. I'm assuming this is because the time hasn't passed yet?
more than 1 resource assigned to a task
When there is more than 1 resource assigned to a task (Ex: 2 people) and change in RM the percentage of allocation of Resource number 1 , it automatically set the same percentage of allocation to the second ressource. How can we differenciate the specific allocation distinctively other than having to create a second liner…
link between the completion percentage and the Resources availability
If I modifty the Percentage of completion to 100% in Smartsheet after the first week of a task that was originally planned for 2 weeks. will it increase the availability of the resources for the second week ? Is there a link between the completion percentage and the Resources availability. Can this be managed ?
Impossible to fill a form - paid plans problem
Good morning, I recently changed the owner of our paid plans but, since then if someone try to fill the form, receive an error message: "Sorry, you cannot access this form because it was published as part of a free or trial account" We obviously have a currently valid paid plans "Business". What's happened? Thank in…
Is there any way to connect the phone number into the smartsheet contact?
Some Projects need a contact number. That's why i'm asking for this question.
Assigned Resource
Hello My team utilizes smartsheets to assign resources for project within a set time duration. I'm looking for the best solution to determine how to view/flag overlapping resource assignments within the same date periods. Is there a way in the drop down menu in contacts to display if said individual(s) are already assigned…
Resource Management - Way to Pull From Project's Metadata?
My team is looking into purchasing the resource management add-on and we are looking to create custom fields in the project to pull data from the metadata of a project. Is there a way to do this? I can create the custom fields in the blueprint but it doesn't seem to be connecting to anything so I have to manually input the…

Trending in Resource Management

Decimals in % Allocation
I have some cases where someone is allocated to a piece of work for, e.g. 12.5% of their time but the % Allocation field automatically rounds this up to 13% - is there a way to stop this, or amend the field to allow decimals?
Is there a way I can count all the tasks in a gantt chart that occur on any day in a project?
Hi all, I have a project Gannt chart with several hundred tasks. I have a column that identifies which are actual tasks (not roll-up summary tasks). Is there a way I can count the number of tasks that fall on any particular day from the start to the end of the project, to build a 'number of tasks per day' histogram over…
Resource Management by Smartsheet -- Good for Small Business?
Hello! I am helping a small high-end contractor optimize his business use of Smartsheet. His organization has a Business plan. He would like to be better able to track workloads of his organization week-to-week & also highlight when subs are overallocated. Wondering if RM is a good option (or if it would be overkill). His…

Resource Management

Discussion List