-
Make dashboard widgets interactive and drillable (click into segments like Tableau)
Dashboard widgets are currently mostly static. I can display counts and charts, but I cannot click into a specific part of a widget to drill into the underlying records. It would be a big usability improvement if widgets supported interactive drill-down. For example: Click a bar segment (or stacked segment) to open the…
-
Dynamic Array Formula Help
GOAL: Create the most efficient formula that can drag across from Column "1" Row "2"and down as project budgets are activated (by form submission adding rows to the bottom of the sheet) and subsequently drawn down. Target Sheet has 60 project budget columns to the right of Project Kickoff, most blank, to allow additional…
-
Self-Contained Process Management
Hello all! Wanted to share that I've had several success stories using Smartsheet as a process tool that is self-contained with high visibility for every point within a process with nearly 0% process leakage. I use Smartsheet internally for change management engagement tracking, task tracking within a specific engagement,…
-
Successor tasks have mysteriously changed to start the same day predecessor ends
While reviewing a timeline created several days ago I realized that successor tasks are suddenly starting the same day predecessor tasks are ending. For example, Task A ends on 4/10/26 and task B begins on 4/10/26. Previously, task B would begin the following day, in this case 4/13/26 because Saturday and Sunday are non…
-
Timelines basics courses?
Hi all, I’m looking to get more up to speed with Smartsheet timelines, especially features like Gantt charts, dependencies, milestones, and overall timeline best practices. I’ve already built out one sheet and understand the basics, but I’d love to learn more about the tips, tricks, and best practices that more experienced…
-
The "Master Program View" (Dynamic Sheet Aggregation)
Problem: Current Limitations Reports are "Flat" Lists: Current Reports can aggregate rows from multiple sheets, but they function as static lists. They cannot perform project logic (dependencies, duration calculations) across those sheets. No Cross-Sheet Critical Path: There is no native way to identify a "Critical Path"…
-
How do you create a dynamic list of unique values from multiple sheets?
I am trying to create a "level of effort" calculation where we compare the count of bidded, lost, and awarded projects against a specific criteria, which is often a dropdown column in the source sheet. I have tried using JOIN, COLLECT, and INDEX from at least a dozen posts in the Community but nothing has worked to date.…
-
In Control Center: Link Assigned to, to Project Team on Intake
I have Control Center. We are set up to where the project team is not entered when a new project is created. The column is there, but the requestor doesn't necessarily know how the project team is. As we build out the project plan, I would like to have everyone that is "Assigned To" a task, auto-populate the Project Team…
-
How do I list all predecessors (direct and indirect) for a given row?
Does SmartSheet have a way to list out all of the predecessor rows that feed into a given row? For Row 22 in the example below, I would like the formula to return the values 20, 19, 18, 17, & 16. Either that, or I would be looking for a list of all direct and indirect successors to a given row. Either would get me where I…
-
Merged: Dynamic View Grid Lines / Column Freeze
This discussion has been merged.