-
Product Development Inflight Project Dashboard
I feel like I've looked at all of the templates and am still stumped on which one I would use to display a 2023 - 2024 project dashboard. Currently my boss put it in a Excel but not in a way that you can sort. I want to be able to use Smartsheets to input all potential product launches under each of the categories. Below…
-
Linking Green Health Indicator with Not Started Status
Used this ask a question feature for the first time last week and it has been a lifesaver. Here goes another one... How do I update my formula's to show the following. Not sure if I need to update both the health and status, or just the health. Show status as 'in progress' if the start date is greater than today's date…
-
PMO Project Intake Sheet & Project Metadata
Hi, I'm using the PMO template to create the intake sheet and metadata. I see where in step 1B you can edit this column. What are people editing this column to say? Does it has to still be a drop down? What if I don't have an edit, can it just be deleted? I'm thinking I can't based on the note below.
-
Card View - Conditional Formatting
Hi all (Andre you about? haha) I am trying to conditional format on the card view, in terms of striking through the Primary Text (Task Name) when the % Complete column = 100% This works on the grid or gantt view however does not carry over to Card View...any ideas? See attachments Any help much appreciated, Jack
-
Can SmartSheet Count & Return all other values besides "X"
Hello Everyone, I have a metrics sheet that is counting specific text ("Alpha") from a source sheet with the following formula: =COUNTIFS({Supplier}, Description@row, {Status}, "On Order") **This works** Ideally, I would like to count all the non-blank cells that do not have "Alpha" inputted. Can this be accomplished?…
-
Project Schedule Health from PMO Template
I've search the community and I think I'm just getting myself more confused since I'm not good with writing formula's. I downloaded the "project plan" template and I am still confused. I would like to show the following (I hope I'm explaining this right 😩): Blue (complete) = if schedule delta is = 0% AND % complete is 100%…
-
Formula to look at specific column/cell depending on the current month
Hello, I want to create a dashboard widget that will show employee FTEs for the current month. I currently have a sheet (Capacity Plan) that list out the employee's name, and then has the assigned projects with FTE breakdown as child rows underneath. Then I have row that calculates the total for the month. For the widget,…
-
Will the 2023 Project Management Path eLearning earn PMI PDUs?
With the release of the 2023 Project Management Path eLearning I am curious if the course will provide PDUs for PMI Certifications such as PMP. If so, how many PDUs will be earned? Additionally, it mentions that the user must be core app certified prior to taking it. If you have the 2022 core app badge do you need to wait…
-
Overall Project Status based on frequency?
Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Completed. I am trying to set up a formula that will return the most frequently populated Status per unique Group and also…
-
Embeding forms into a dashboard that is part of a Control Center Template Folder
Hi, I'm finding difficulties when trying to embed a form into a dashboard that is part of a template folder for control center. Due to the fact that this form is embeded through a link, the form keeps it's original destination sheet when a project gets provisioned and the new dashboard gets created. In other words,…
