-
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…
-
MS Project Import Question
Hello all! I did a search, but can't find this exact situation in the community. I'm currently creating and updating a schedule in MS Projects and then importing it into Smartsheet. I've found that when I'm in the schedule in Smartsheet, select "import" and choose the MS Project file, it seems to create an entirely new…
-
Assigning multiple people to the same project, visible in Card view
Hello! I would like to be able to have multiple values per cell in either dropdown or contacts column, & to still be able to use that column as a swim lane in card view. eg: I have 2 people to assign to 1 project. When I select multiple names in the 'Responsible For' column then switch to card view, I can't view by my…
-
Project Name for Project Status Log and automations
I'm working on a global update where I want to add a column to reflect the project name so all the automations include the correct project reference. We use a template that is consistent for every (new) project created. My goal is to add this new column to the overall admin template so both existing and future projects…
-
Are there any businesses located in Christchurch that use Smartsheet for PPM?
Hi, I'm new to Smartsheet and am interested whether there are any businesses located in Christchurch, New Zealand, that make use of Smartsheet for portfolio and project management. I think this is the solution I've been looking for and would like to connect with local users to speak in person about the capabilities before…