-
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!!
-
Index Match Formula help. Index Match of Health status of an activity into Sheet Summary
I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index Match formula to search for Task A in Task Name column and spit out Health symbol. =INDEX(Health:Health, MATCH("Task A",…
-
Alert when tasks are planned to finish after a date in another task (deadline)
Hello all! I am trying to program a sheet to alert users when any finish date in the sheet goes beyond a specific deadline task in the sheet. I foresee it working like: User changes a start date, and several tasks down the dependency waterfall, a finish date gets pushed beyond the deadline task's date, and an error shows…
-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
-
TotalFloat with multiple phases
Hello, are there recommended best practices for handling dependencies when calculating TotalFloat, =TOTALFLOAT([Primary Column]@row)? In this example, Milestone 0 requires that Tasks 1-3 be completed and is a predecessor for beginning the next project phase. TotalFloat calculates values for tasks 5 & 6, but it does not…