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”…
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…
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…
*** 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?
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…
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 ?
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…
Some Projects need a contact number. That's why i'm asking for this question.
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…
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…
We use Smartsheet for several data repositories to feed data into other sheets via formula. We are running into issues because of the row limit in sheets. Will you be adjusting the sheet row limit, if so when?
Hi all and @Genevieve P. ! We recently had help setting up a Project Management Office workspace to create, track and report on all projects going through our company. We also purchased the Resource Management software to manage resources. Part of the goal is to create the projects in Smartsheet through the PMO workspace,…
For Resource Manager Users is there an easier/automated way to export People Data from RM? Currently the only option available it to "Export People List" which downloads a .csv file that has to be loaded manually into downstream/dependent systems.