-
Sort and filter on a report in Smartsheet without being an Admin on the connected sheet
Is there a work around to sort and filter on a report in Smartsheet without being an Admin in the sheet it is connected to? Even when the person is an Admin on the report
-
How do I have tiered authorizations?
As noted in the attachment, what I am looking for is a system of sign-offs where each person can sign off on a document and then it automatically fowards to the next person in line OR if the have changes, it gets sent back to me.
-
Folder (Highlight) Colors within Workspace
I have access to multiple folders within my workspace, like everyone does. I would like the ability to highlight folders. And my highlighting would be exclusive to my account. Others that have access to the same folders would not see my highlighting. The main folder names (mostly created by others), are so similar. I often…
-
Formula for rolling up children status to parent rows
Hello, I am trying to simply roll-up my children status' to their parent row. When using this formula: =IF(COUNTIFS(CHILDREN(), @cell = "Complete") = COUNTIFS(CHILDREN(), OR(@cell = "", @cell <> "")), "Complete", IF(COUNTIFS(CHILDREN(), @cell = "Not Started") = COUNT(CHILDREN()), "Not Started", "In Progress")) I receive…
-
Dates in Timeline View are not the same as Grid/Gant View
Does anyone else have the issue where the dates in the Timeview line (mainly Milestones) are a day ahead of what they are in Gant/Grid View. It seems to be correct for some milestones but not others- I can only assume it's to do with predecessors with/without lag. As you can see on my screenshots, the ones highlighted…
-
Merged: If Status is Complete - End Date is Updated to Today's Date - With Dependencies/Predecessors
This discussion has been merged.
-
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,…