-
Hours/Minutes in Project Sheet
I want to be able to make standardized work documents for changeovers/process information. I can't do that in smartsheet due to the lack of hours/minutes in the project sheets (I want to have the gantt chart to the right) Of course I could do something like scale it with the days with 1 day = 1 hr and just ignore the wrong…
-
Repeated Task
Hello all you wonderful SmartSheet users I am trying to find a way to represent a repeated task and the associated information (Start /finish Dates, Status, % complete) from the first time this task is completed. i.e. I have a drawing and its associated sub tasks. This drawing is a sub-task in a later drawing. As such, I…
-
Ability to copy all content pertaining to a row to another Smartsheet including comments
Need the ability to copy all content pertaining to a row to another Smartsheet. Use Case - Project manager wants to track project data on a Smartsheet. The tracking is done in the terms of: Week 1 discuss training, technical deliverable, discuss networking, etc. Current State: PM marks the technical deliverable as "In…
-
summary of sheet summaries
My project contains multiple sheets that need to be summarize. Each sheet has a sheet summary but since my data spans across multiple sheets, I need to combine the calculated fields in my sheet summaries to be combined (sum, average, count etc). I realize I can create a metric sheet that makes use of formulas and reference…
-
How can I make a graph from a report in the Portfolio level?
It appears that I can only make a graph of the whole report instead of only one column. Is this possible to do? If not, do I need to make a sheet of the data of every single column of the portfolio? For example: I need a graph of the column "Responsible area" of the portfolio, to get the data of how many projects has each…
-
Sumifs That Excludes Parents
Hello, I am working on an ever expanding project timeline that has 100's of parent tasks that flow into potentially up to 10+ levels of parent tasks, with children tasks at every level. Given the granularity of the task management and the timeline being outwardly facing, "=sum(children())" is used on every parent task to…
-
Reservations/Scheduling & WAITLISTING
First time posting, and I'm not sure if I'm doing this correctly, or if this is the right place, please have patience. I have a workspace, with a form, and a sheet (although it's definitely not NEAR as optimal or helpful as it should be), along with a few other sheets/resources (past appointments, contact lists, specific…
-
Cross Referencing Data Across Sheets
I've read several threads on this and tried to figure out solutions but am still stumped. I am creating a workspace for managing events. I have vendor lists with their rates and a planning sheet with the number of staff we need and which activities will be booked, etc. I'm trying to create an expense sheet where I can have…
-
Project Plan Reports
Is it possible to have a report that pulls ONE task that is the oldest task (date-wise) that is not 100% for over 20 project plans? So this would be one report with 20 rows, all representing a different task that is the oldest incomplete task. Is this possible? If not, is there a formula that pulls the task name that I can…
-
Formula on Project Plan
Hi, I have five stages on a project plan, parent row s, with numerous child tasks underneath. I want to have a formula that marks child tasks based on this formula: =IF([% Complete]@row = "1", "ITEM COMPLETE", IF([% Complete]@row = "0", "ITEM NOT STARTED", "ITEM IN PROCESS")) The parent rows also have this formula: =IF([%…
