-
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.
-
Merged: Changing Finish Date based on % Complete Column to Update Schedule for Predecessor Tasks
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…
-
Drag and Drop in Timeline view
It would be great if I could move the boxes around in Timeline view by dragging and dropping. Currently the only way to move them is to edit the dates in either the box details or the grid itself.