-
Task status and Completion % not syncing b/w sheet & Resource Management
Resource Management currently has a huge gap due to the 'status' and 'Completion %' not being pulled into the Resource Management 'Schedule' view, which makes it impossible to filter out the completed tasks. So, if one wants to do the resource planning for only the incomplete tasks, they will have to duplicate their…
-
Copy parent row only
I have automation set up to copy rows marked as "key deliverables" in my project schedule into a separate, key deliverables status tracking log. Unfortunately, when a key deliverables row in the schedule is a parent row -- i.e., has subtasks under it -- the automation (rightfully) copies the parent row AND its child…
-
Copy&Paste with relative predecessors
Hi, I have a schedule (created from Project template (aka Gantt chart)) where I have a section which is repeating several times in the schedule. Inside of a section I have dependencies linked using Predecessor field which do not point outside of the section itself. You can imagine this as an agile sprint schedule where…
-
How do you implement Deadlines?
This is sort of a feature request, but I'm posting here to see what other people do in Smartsheet or maybe even other planning software to show a deadline. It's a funny thing, as I've seen this better implemented in hodge-podge put together spreadsheets than I've seen it in actual planning software. In such spreadsheets,…
-
ISCRITICAL for Parent Tasks
Currently, Critical Path does not propagate from a Child to the Parent Row. Create a functionality or a new formula for ISCRITICAL to show on Parent Tasks, maybe even up through a specified number of levels in a hierarchy.
-
Gannt chart showing additional days when weekend working
When project settings include for working weekends, why when you give a task a two day duration starting on a Saturday, does it show it spanning 3 days (Sat, Sun, Mon) ? Is there a fix for this please ?
-
Editable email Subject header from Smartsheet Notification
Hi There, I would like to propose that Smartsheet considers the email subject header that is received from a Smartsheet notification from a form or sheet. Currently, because not everyone in my company has Smartsheet, let alone a Smartsheet log-in, we need to send show the name of the owner of the sheet, that appears on the…
-
How can I automate dashboard charts?
Hi everyone, I'm fairly new to Smartsheet and looking for some advice. I'm in the process of building a project portfolio dashboard and would like to automate a 'Workload Distribution' chart. Currently, I have to manually update a separate metric sheet that serves as the data source, however, with how frequently the data…
-
Using both 5 day workweeks and 7 day workweeks in one sheet?
Has anyone had any luck with utilizing both workweeks in one sheet? I have some tasks that need to include weekends, but others that can only be strictly worked on during the workweek. The dependencies remove any logic that I try to apply beforehand.
-
Enhance Row Collapse Functionality for Improved Project Management
Our team manages a large number of projects on a single Smartsheet, with each project containing multiple child rows to track weekly progress and phases. This results in an extremely long sheet, making it challenging to navigate and manage efficiently. Our management prefers to have all projects and phases listed on one…