-
Portfolio Gate Reviews
I have 165 projects in the portfolio, each with 5 gates and ~120 steps in a project. As an example if a project has successfully passed gates 1&2 and is coming up on gate 3 review, I want to be able to see the rollup at the portfolio then "zoom in" to see the project plan details for a specific project and gate 3. With my…
-
Count % Completion of Checked Items by Each Sub Project
Good morning Smartsheet Community, I am trying to put together a grid that captures the percentages complete broken down by individual areas of a project. Below are the variables I am trying to capture Percentages To Capture Power Installation % Data Installation % Millwork Completion % Configuration % Installation %…
-
Combine Contacts from multiple columns into a single cell
Allowing contact columns to be combined into a multi-select contact column would make team management and index sheets much more useful. If Columns 2 through 10 on my sheet are all contact columns, a formula like =Contact2@row + Contact3@row + Contact6@row should produce a multicontact cell, not a text cell. That would…
-
Need Help With Date Calculation Formula
Hello, I have 2 date columns. I put a test sheet together for a visual reference. The Date 2 column needs a formula to calculate whichever date 39-45 days out is a Friday. Any help would be greatly appreciated.
-
Permanent Row ID's without using Auto-ID
Is there a trick to creating a column of unique values for each row that will not change after it is created? I cannot use Auto-ID because the row then gets copied to another sheet that utilizes Auto-ID and Smartsheet limits that. I'm stuck and ChatGPT keeps making recommendations that don't work.
-
Health and Wellness Solution
Good afternoon everyone. I am building a Health and Wellness Solution on my personal account to keep track of my health by logging things like; water intake, exercise (including type of work out, est calories burned, etc.), food intake, sleep tracking, weight log etc. Has anyone else done something similar using…
-
Dynamic Dashboard Filters
I would like to add two dynamic filters as a widget within my Dashboard to define a date range (start and end date) which would then return a count value to that same Dashboard. I have been searching for answers but am not coming up with the solution I'm looking for. What is the cleanest way to configure this?
-
Anyone resolved 'automatically adding rows to a sheet based on a trigger value' ?
Hi Community Facing a problem many others have posted about, but haven't seen a solution yet and wondered if it had been solved. I want to be able to add a row on a resource sheet for each project resource once a project has been set to 'X' on a Projects sheet. I have tried through automations but the daisy-chain limit…
-
Autopopulate / Copy Certain Cells To Another Sheet
I have a sheet that has all of our orders on it. I have other sheets "Gantt" for each machine. I want each machine sheet to auto populate every order that is assigned to it, when an order gets assigned to the machine. I don't want to set an automation to copy the row from the orders sheet to the machine sheet because I…
-
CountIfs Formula between two criteria
I am trying to do a formula that will pick up the tester and also if it is between a set of range of dates. I did one formula picking up the name, and one doing the set of dates. When I combine the two, I am not able to get it to work. Could someone tell me what I am doing wrong. I am hoping this formula will show the…