-
Timeline & Portfolio Visibility for Multi-Project Reporting
Hi Everyone, I’m exploring whether Smartsheet can support a portfolio-level timeline view for our leadership team. I’m aware of the Timeline feature, but I’m looking for something more flexible and consolidated. Ideally, project managers would be able to select specific milestones or key tasks to surface on a shared…
-
Move data from one sheet to another without a Data Shuttle
I have my main sheet and I have a second sheet that where a Data Shuttle (staging sheet) is ran and then it filters out duplicate data. Is it possible to move the data from the staging sheet to the sheet in a way that does not require it to be exported to excel? Is a DataTable an option to upload from the staging sheet to…
-
How to link Task Start and end Dates to another project template file using a formula
I would like to update one task in another project sheet and have it automatically update on another sheet that showcases the more detail project specifics about that installation. I have thought about using the Index and Match formulas, but that would have to hard code the date and the date would be changing.
-
Joyful Animations - in Smartsheet!
I am proposing bringing a bit of pizzazz to Smartsheet by having celebratory animations for certain criteria. Think Joyful Animations in Outlook! My team was hoping to have some sort of confetti pop/gif/image when we close out a project or hit a milestone. Bonus points if it is configurable like the automations are.
-
Need help with formula to pull list of chapters that are past due
Hello, We use very large SS and I'm trying to fully automate our status reports. In our Schedules for each chapter we have 3 rows of data, planned/revised/actual. I am wondering if it's possible to write an equation for each column that would do the following: Look at the same chapter number rows If the planned date in the…
-
How do the hours work in the “Report time for something else” feature?
I've been trying to use the “Report time for something else” feature in Resource Management, under the Time & Expenses tab. However, even when I assign hours to a project and those hours are approved by the approver, no task appears in the Schedule tab. How do these hours work? Do they only affect reports? Where can I view…
-
Formulas and functions for tracking delays
Hello! I would love some guidance on if there are any formulas or functions that are useful for tracking delays with a project. More specifically, our organization is hoping to track who was responsible for the initial and subsequent delays with a project. In our sheet, we have columns for: Task, Assigned To (Dropdown),…
-
Automation won’t stamp “Last Changed” date when Status is formula + linked cells
Hello! I’m trying to timestamp when the value changes in a Status column I've created, but the Status column is formula-driven and its inputs are linked cells / cross-sheet references from multiple source sheets. In my Master sheet, the Status column is a formula. The fields that drive that formula are not manually edited…
-
Using Forms to trigger the creation of a new Sheet
It would be valuable if Smartsheet Forms could trigger the creation of a new sheet from a predefined template or configurable sheet structure. Use case: standardising project plans In an enterprise environment, we often need to capture mandatory project setup information through a form before work begins. This ensures…
-
Incremental Baselines & Dynamic Baseline Linking
Problem: Current Limitations Destructive Updates: Currently, snapping a baseline is a global action for the entire sheet. There is no way to baseline newly added scope (new tasks) without overwriting and erasing the historical variance data of the existing tasks. Manual Data Entry: Users are forced to manually copy/paste…