-
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)…
-
How to get project overall delay in days in Smartsheet
Hi While we use the Baselines on the task level to see the delays per task, is there a way to grab the overall project delay in days and also show it in the Dashboard? Thanks for any prompt Regards /Marat
-
Creating CRs and Linking to main project in Project Management Office Template
Using the Project Management Office Template, is there a way to create and link Change Requests to the same project folder for tracking, identifying, and maintaining CRs related to each project in one folder that also can reflect to the Portfolio dashboard?
-
What does your university use Smartsheet for?
I'm curious to know how other universities are using Smartsheet.
-
How to Identify Duplicate Job Numbers on Multiple Sheets?
I manage 30 production projects across three Smartsheet sheets: one main sheet (Project Management) and two spin-off sheets (for Ordering and Install Certification tracking after a project ships). All sheets use a unique 4-digit job number for each project. What’s a formula or function I can use to quickly identify if any…
-
Creating A Report of Missing Submissions
Hi Community! I have a form deployed to community partners. These partners need to submit a report 1x per month. Of course, some do not submit the monthly report. Is there a way for me to create a report of missing submissions? I have a reference of all partners who should be submitting a report and the sheet from the form…