-
Resource Management by Smartsheet is now localized in additional languages
Exciting news! Our latest release of Resource Management by Smartsheet enhances our global customer support by providing seamless language compatibility. Now supporting the same languages as Smartsheet - English, French, German, Italian, Japanese, Portuguese, Russian, and Spanish - it leverages automatic detection based on…
-
Assign Contacts to Child Rows Based on Criteria in Parent Row
We have multiple stages in our projects that are set up with a parent row and then child rows below. I would like to assign a contact to the parent row of a stage and have that contact automatically assign to all child rows below. Is there a way this can be done without add-on software?
-
Auto-numbering automation
Hello I have a sheet, that uses numerical ranks to keep track of projects. These ranks are simple number assignments (i.e: 1, 1.1, 1.2, 2, etc.), that we use to determine the priority of the project. If a project changes priority, or we have a new project that comes in at a high priority we have to manually update the…
-
can't see the data on report despite that there is data on the form, what is wrong?
Since days ago I can't see anymore the Data of my active project report, despite that the project intake sheet has the information. I try to create a new report, also try to filter again, to make a copy of intake sheet and create a new report, but nothing works Help
-
Is there a way to have a column automatically pull data from multiple columns based on the month/yea
I have a master sheet that includes data for multiple projects from different months. I'm trying to generate a column that pulls the data from the current month. The intent is to create a cell that populates automatically and can be referenced on a dashboard. I have tried to use the index/match formula with no success. I…
-
Multiple Critical Paths in Single Project
The last task/activity in my project plan is not the "end" of the project, or at least not the end that we care about for reporting purposes. I work in pharma, and our project sheets are tracking toward their NDA submissions, which is the "end" of the project that everyone cares about when it comes to executive reporting…
-
Health Bubble Turn Colors when Status is Updated
Hello, I am new to Smartsheet. I am trying to get when I change my Status to "Not Started" I want the Health bubble to automatically turn grey. And when I change my Status to "In Progress" the Health bubble will turn yellow, etc. So far I have: IF(Status1 = "Not Started", "Gray", " "). I want it to change color for each…
-
Restrict a Checkbox from Getting checked (With out Using Dependencies)
Hello, I'm trying to restrict a Done checkbox from getting checked before other boxes are checked first. My team created a project plan with multiple steps in the process. Each step has a done checkbox. I have a formula that fires when a specific box is checked but don't want folks to check that off sooner than they…
-
Pre-populate a form
I am building a change control log. Is it possible to pre-populate a form with cell data from a sheet? For example, project name, ID, customer, description and resource from the sheet to help the process of logging a change to the change control log.
-
Hidden Phases - functionality
My company is trying to log "client travel time" (aka not consulting time) for projects as a separate phase for any given client project. That said, travel time wouldn't be logged too often and we have a preference to not have is show up automatically on staff's timesheets. I'd rather allocate the bank of hours to any…