-
Easy Question : % Complete
Hello, How do I get my % data to roll up to 100? Its looking like all of the data is running up to 1. Does that make sense? Sorry for the hopefully easy questions. Thanks - Alex
-
Critical Path - Where Smartsheet fails - Need a Critical Path filter ASAP
I don't know about you, but I'm constantly being asked about speeding up our projects. Yet, Smartsheet actually hinders my ability to expedite projects. Before Smartsheet, one important method I used in MS Project was the following: 1) Filter to show only tasks on the critical path. (This usually reduces a 400-line project…
-
Counting how many times a milestone slips
I would like to add a column that would count the number of times a milestone has slipped. My thoughts were to add a column in front of comments (see attached) and count the number of instances that the finish date has been edited. I thought of using the COUNTIF function, but unsure how to get the cell to count on a…
-
Charts
Hi Guys, Literally just started on Smartsheets, I have created a RAID Log template and was hoping to create a dashboard that would complement my log. Unfortunately every time I try to fill in the data the system tells me my data is invalid. Could you help me how to make this DATA fit in some sort of chart. I know this is…
-
Gantt Chart Start & Finsh dates Change
If my Start or Finsh date changes from the orginal schedule how can we show the progress or delay in the schedule. Currently I'm re-entering the Start or Finish date. So I'm lossing the orginal to show us any gains or losses. I do not want to loss the predecessors link to the task.
-
Image In Parent Task Reference Broken
The following PARENT image cells in Grid View used to transfer to a image in the CHILD. Now, instead of having the image, in this case "hr.gif", display inside the card in the Card View, the card displays "hr.gif". Can this be fixed to work like it did?
-
Linking the text in a cell to a document
If I have a PO # that occurs in multiple cells. Is there a way to link the PO# text to the actual document? I don't want to link the cell to another sheet. I want to link the PO# text to the actual PO document. So a team member can simply click on the link to view the PO.
-
Mobile app doesn't show dashboard graphs
I can't view any of the graph widgets on the mobile app. Is this a known issue or are my settings wrong?
-
Auto-send PDF Gantt chart of project schedule
We want to be able to auto-send a PDF of projects to our clients on a weekly basis. Can we do this somehow? I know we could share a report for them to view at their own convenience, however, we can't be sure that they will log on to view it regularly which is necessary. to make it easier for them, we would like the option…
-
Formula Assistance
I am attempting to automate my project list by scoring each project based on calculations in another sheet. I would like to create a "Project Score" based on drop-downs in my project sheet. Sum=Complexity*weight + cost*weight + impact*weight +resources*weight + value*weight. The values of each category and weight are in…