-
Cascading timelines by linking timelines
I have three grid sheets, named Sheet 1, Sheet 2 and Sheet 3. The timeline of Sheet 2 is dependent on Sheet 1 timeline and the timeline of Sheet 3 is dependent on Sheet 2. I want a function wherein if the end date of any one task of Sheet 1 gets changed then it automatically changes the start date of the task of Sheet 2 or…
-
Any LMS/Content Managers using Smartsheet to track their content? Do you mind sharing?
My team manages training content for a specific part of our organization and we have content that can be as old as 2016 to as new as of yesterday. For a few weeks now, I've been trying to figure out a way to track "content" (right now, just LMS courses) we own in Smartsheet so I can share with leadership "This is…
-
Merged: Add Gantt View to Dynamic View
This discussion has been merged.
-
Collapse When Completed
When the completion marker (ideally configurable based on a selected column) is "complete" the hierarchy for that parent item should collapse to free up space since those child items are no longer part of active work. This would make long-running projects/sheets much easier to manage by displaying only the active work…
-
Populating parent row status based on different combinations of status from child rows
I am using the formula below to populate my parent status but I also want the parent status to say "In Progress" if the child rows are any combination of "Complete" AND "Not Started". Right now when the child rows are a combination of "Complete" and "Not Started" the status will read "Not Started". How do I get that…
-
What happened to my critical path?!
Good morning Ss Community! I found some great answers, especially to this question: Why don't I see the critical path? — Smartsheet Community so I have already tried some of those suggestions: * sort by Start Date for chronological list of tasks helped the view but didn't fix my issue (see below for details) * task spans…
-
Does anyone know how to use "Row Link" in reports?
I have rather long project sheets and several standard reports (Over Due Tasks, Tasks Due Next Week, etc) and include "Sheet Name" as a column in all. Each person is active on multiple sheets (projects), so all their assigned & active tasks show across all project they're on. This gives an easy link to the project sheets,…
-
Template from Engage Session
I was lucky enough to attend Engage this year in Seattle, and I attended the "Advanced power-user tips to up-level your Smartsheet experience" session. I was excited to use the template for Multi Entry Form that was provided via QR code from the session deck, however, it appears that at least one sheet is missing from this…
-
Smartsheet Implementation: Overcoming Common Challenges in Change Management.
Hi everyone, I wanted to share some insights on how we’ve been using Smartsheet to tackle some of the most common challenges in change management. Whether you’re dealing with leadership alignment, struggling to keep projects on track, or facing difficulty engaging teams during a change process, I’ve found that having a…
-
Forumla Help: IF Statement with Vlookup Across Sheets
I have created two resourcing documents (pictures below for a visual) Resourcing Sheet - This is the sheet where we resource each project by person Resourcing Rollup- The sheet is rollup to show how many hours the are allocated each week by person and gives a rollup of hours What I am trying to do: Look up (example name)…