-
gantt chart - dependencies that are not necessarily SS or FF (or any other combination)
I have a project where Activity A is anticipated to run for a month. And Activity B starts around the same time, maybe a little later (start date is independent of A).. however B can NOT be closed out until A is complete.. AND B has a hard stop due date. how do I set THAT one up? cuz I don't want B to automatically shift…
-
Calculating Weighted Percentage of Projects
Hello, I'm hoping someone can point me in the right direction. I want to be able to visualize the amount of work each Project Manager has in order to best balance the workload when assigning new projects. In order to do this, I've created a Project Tier system based on the complexity and importance of each project. I've…
-
Best practice for cross-team project dependencies and consolidating reporting?
Hi everyone, I am looking for advice on the best way to architect a cross-team project tracking system. My current setup: I have multiple teams, each maintaining their own individual project sheet. Each sheet contains a list of projects specific to that team. The Goal: Cross-team Dependencies: I want to add a dropdown…
-
Project Management Solution
Hello, I wanted to share a recent solution I was involved in, what was brought to me and what I did to help this group get the data that they need. I work in Healthcare and our org is switching to a new lab software that will require inventory assessment and identify needs for additional hardware. We have over 700…
-
Does Automation Not Work with Formulas?
I'm trying to build workflows where: Sheet A: has my data Sheet B: is my target sheet. Based on an Index/Match formula, I want to record a date automation when X value changes based on the INDEX/MATCH formula. It worked when I used to update it with Data Shuttle, but no longer does with automation. A similar second…
-
Column Formulas that look at values in the row above
I'm building a vehicle tracking log in which users enter trip information from a form. They include the vehicle mileage at the end of each trip. Each trip is logged as a new row in the main tracking sheet. I'm trying to develop a column formula that can calculate the trip mileage by subtracting the ending mileage entered…
-
Count IF - Numbers as Text
I'm trying to identify the duplicates in a row. So I'm using the formula: COUNTIF([Identification Number]:[Identification Number],[Identification Number]@row) The issue is that in the Identification Number column, I have Numbers stored as text such as: 0854932479 and also a combination of text and numbers: 9174613SW. So…
-
Dashboard Data Not Loading Unless Metric Sheet Is Opened - Possible Performance Limitation?
I have a build that functions within the following Smartsheet pipeline: Current Structure Form A master intake form that feeds into a master intake sheet. Master Intake Sheet Contains approximately 40 columns of data/questions. Currently holds about 1,600 rows of submitted information. Metric Sheets Approximately 20…
-
Reports - Pull a Rolling 12 Months Instead of YTD
I have reports that filter out by specific dates and other criteria. Ex: 1/1/26-12/31/26. I just had a request to try and pull the data from the rolling 12 months (8/28/25-8/27/26 or something) instead of year to date (like the example above). Is there an easy way to do this without having to manually update the dates in…
-
Date & Timestamp a specific cell change
Hello, I am very new to Smartsheet and I am working on a project tracking sheet. We have the following statuses in a cell: Unassigned; In Progress; Completed; Cancelled; On Hold When a request is submitted this automatically triggers a 'Created Date' column that logs the date/time of creation. I would like this to be…