-
Checkbox formula using =IF(OR
Hi, I am trying to find a formula to check a box based on another cell in the row having either maintenance OR support (along with other text) but keep getting an #INCORRECT ARGUMENT SET error. The formula works perfectly for one criteria i.e. =IF(FIND("Maintenance", $[Item description]@row) >= 1, 1, 0) but when I try to…
-
Adding 2nd product line to existing Project Management Office (PMO) workspace
I have setup the PMO workspace and use it for onboarding our primary product. I have an Intake Form which links to or from Metadata and Project Plan sheets. Links are working properly. I have been asked to setup the same for a secondary product which my team onboards. The tasks (project plan) are entirely different. I'm…
-
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…
