-
Conditional Formatting on Parent Line
I created conditional formatting that allows me to color code based on % complete of child tasks, however this does not carry into the parent line as I have dependencies enabled. I would like to be able to visually show the progress of a project based on the average of the children status on the parent line.
-
How can i see who has changed which portion of the sheet?
Hi, I am having a situation wherein we are 2 Admins sharing the same Project sheet. I know that this is not the best way of handling the project/sheet. I would like to know, how do i see which portions of the plan is updated by my counterpart? I see a message that some changes are done and i need to refresh the sheet. I…
-
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…
