-
Project Timeline Comparison
My goal is to be able to compare one schedule (prediction of time to complete tasks/project) to another (actual time to completion). I need to be able to show the difference in time spent between the anticipated project timeline and the actual project timeline. Any tips or suggestions? Is there a way overlay one project…
-
I would like to hire an experienced consultant
I am relatively new to Smartsheet. I need someone to help setup Smartsheet to manage our book production schedule. We publish books (print and e-) and have managed our production schedule for many years with a Google Sheet. It is severely lacking. I have not yet signed up for any plan. I don't think I'll need 3 licensed…
-
Formula return Column date plus 7 days IF column value is less than 3
Hi, I am new to smartsheet (spreadsheets in general) and I am trying to create a task list sets a due 7 days after a task was created if the priority of that task is less than 3. The formula i have so far is: =IF([Priority]1 < 3), [Created]1 + 7 I get an error saying Missing or invalid parameters. I'm not sure what im…
-
Allowing for unresourced time requirements
I'm evaluating using SmartSheet for project managing construction projects. So far, so good. One of the requirements is to allocate time for processes such as plaster drying out. So no resource is required, just a number of calendar days, which can include weekends/holidays. I can set up a "task" for this with dependency…
-
Multiple Duration columns (or a way to calculate number of day between two date columns)
I'm trying to setup a sheet for tracking actual work dates vs target dates Construction Document set timing. In each deliverable/row I'd like to list the following dates: • Target Date * • Act Start * • Act Finish * • Approval Date I have my the project settings turned on so that "Act Start" and "Act Finish" create teh…
-
Real time & ressource management
Smartsheet is a great product with great features, but it lack in crucial features for any real event and logistic planning. Add time/duration management for task When selecting a start and end date for a task, we should be able to select a time for it as well. We cannot be limited to fixed hours work day or using "gaps"…
-
Hierarchy in Reports
Is there any intention of offering a hierarchy in the Report view? This would be especially useful where the report includes parents of the items found for the report. Thanks in advance, Neil
-
Portfolio Report based on Projects & Gantt incl. milestones (1 line)
Hi, I made a report based on our active projects, showing the gantt chart.. (We have just started using Smartsheet, so not all of our projects have the right data) What I would like to see in the Gantt chart are the milestones. Is that possible with some nice adjustements (or clever tricks ?). Teach me, I haven't found it…
-
Gantt report: Knowing Real progress percentage vs. Expected percentage
Hi. As is somewhat difficult to explain for me in english the requirement that I have, I'll use the google translator. I need to know if it´s possible to have by a Gantt report: -To be able to see on any given day (usually the day that I require to present a progress report works) that have real progress percentage vs.…
-
Dependencies, critical path and changing dates
Hi everyone, I have some issues with the dependencies function in Smartsheet and was wondering whether someone could help out. I am really keen to see the dependencies and the critical path, which are possible in SmartSheets. However, I found two issues... * 1. I would like to be able to see, that if I want to change a…
