-
Create Task Start and Finish Dates with Mouse in Gantt?
Is there a way to create start and finish dates in the Gantt chart view by simply clicking/dragging on the Gantt chart calendar? It seems the only way to initially create a start/finish date is by using the Start column and clicking on a date on the calendar that appears. This is clunky and it would be much easier to just…
-
I would like to send my sheet to users for viewing purposes and only want them to have the ability t
I'm sharing my sheets w/ external vendors and want them to view all the data but only update their comments (1 specific column). 1) The update request does not allow the abiity to change some fields from edit to view only. 2) The update report is ok but does it send a request to the spreadsheet owner? So far i'm not…
-
Need the ability to filter reports based on project status
Here is what I need. I have about 50 projects within a workgroup that I am trying to manage. I have a report of tasks that are due within the next 5 days. Took some cluncky work to differentiate tasks vs summary tasks, but it was easy enough to do. Next issue / challenge. When a project stalls for some reason or another, I…
-
Trying to build a good, dynamic task list
I'm working on getting a good personal task list system going within Smartsheet. I've gone through a small number of efforts to get what I need, but I still have a problem around getting something dynamic and quick functioning. 1. Built a task list based on the task list template. With no automatic sorting, I have to sort…
-
How to send a notification to a selected recipient
How do I get SS to send a notification to a contact whose name has just been selected from the list and entered in a webform? Like, when column [supervisor] is set with a particular name, please notify [selected supervisor] of this change.
-
Improvement Recommendation
I have been working on 10 different sheets tonight, I am not done but I am off to bed. It would be nice to be able to set a reminder for sheets that I am working on, or more specificaly an update from the Dashboard for resent sheets. It woudl be nice to have an email sitting in my inbox reminding me that I need to finish…
-
Impact analysis/Traceability?
I'm wondering how one would address this for managing changes to projects? For instance, in tools I've used in the past, I can answer the question "for the tasks/requirements that are at risk/due soon what would be impacted if it weren't completed?" and or "If I change this item, what is the ripple effect to my other…
-
Cost Data Not Exporting to Microsoft Project
I am a hardware engineer. My project engineer starts by handing me a Microsoft Project file so I can fill in the details of how long each task is going to take and how much cost will the labor and materials will be. I prefer importing the project file into Smartsheet so I can easily arrange the trench work and subsequently…
-
Is there a way to apply conditional formatting or grouping to reports?
Looking for a way to utilize the reports functionality. It would really help to have conditional formatting capability as well as grouping functions.
-
See summarized duration/ % for header tasks
I have created a master sheet that links all my project gantt charts. Unfortunately I cannot see the summerized totals - is this available as an automatic function? I've been manually typing it in, but I'll have a lot of projects so this would be great if it was automated!
