-
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
-
Is it possible to reset only a part of the baseline date during the project ?
Regarding the start date /end date baseline function, I'm wondering if it is possible to reset the baseline date just for a part of my planning. For example, if I plan my baseline at the start of my project for every task and I activated the baseline function, and in the realization phase, the baseline of only one task…
-
Why isn't the background color of my forms carrying over to new projects?
In the project blueprint, we have forms set up & the background color is set to blue for all forms. However, when we create new projects, the background color of the forms is showing up white (making our white logo invisible). Is there a way to fix this? Has anyone else had this problem of the background color reverting to…
-
Check dates against a range of dates for any overlap?
Hoping to get some guidance on formula to use. Have a scheduled date range in which to get something done. But need to see if there is any overlap of schedule dates against any blackout periods. Sheet 1 has the task to be completed within a start date and end date window. Sheet 2 has a list of blackout periods that work…
-
How to show most frequent status per unique groupings?
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…
-
Project Card Attachment URL's
When I open attached hyperlinks, google docs, etc. from a project card, it opens a new window to navigate to the link. Is there any way to adjust my settings that the link could open in a new tab in my browser? It would help my ease of use GREATLY!!
