-
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…
-
Identifying who is double booked in a meeting at a specific time and date
So I am trying to identify how to see who is duplicated and double booked at specific meeting slots. In the first two rows, you can see the duplicate flag shows up because it is the same exact people in the same order, but when i add "Jordan" on the 3rd row its not showing people are duplicate. Is there a way to show who…
-
Collect multiple project names in Portfolio Rollup?
Data is collected in this example intake sheet below and the metrics are summarized in another metrics sheet below. The following formula collects the Project ID and gives the count per associated Platform and Status. However, I need to display the Project Name as well as the count on my portfolio dashboard. How can I fix…
-
Automated Workflows Limit
Hi Is there any limit to how many "automated workflows" we can create in a single sheet? Asking because one of my projects is expected to have approx 30 automated workflows in it.
-
Calendar App Automations (API + SCC Integration)
Would like to utilize Calendar App within Control Center-generated Dashboards (embedded link), however, these need to be manually generated for each provisioned project. Please consider integrating Calendar App within SCC to allow for calendars to be generated and embedded automatically upon provisioning a new project. The…
-
Drop Down, and Auto fill cell wit color
How do you setup a cell which has a drop down menu with 3 selections YES, NO, and N/A What I want is: If YES is selected the cell will turn Green. If NO is select the cell will turn Red If N/A is selected the cell will turn Yellow Thanks