Project Management
Discussion List
- Hi all, I'm quite new and I'm struggling with a formula I need to apply. I need to have an automated "at risk" status (red, yellow, green) in my projects masterlist. Red: % Done is equal to 0% and the…
- I have created a form that I am using to send to people to sign up for something. I need them to be able to select a date, but have some that aren't available to be crossed out. Some dates will be abl…
- I cannot figure out how to create this formula to get the metrics. I can get each individual dept metric correct using =IFERROR(COUNTIFS({(Phoenix) Project Tracker - Aerial Status}, AND(@cell <> "No",…
- Is it possible to use a formula to generate a percentage in a % Allocation column for use in the Project Resource Manager? Or does a percentage have to be manually entered into the % Allocation column…
- Example: There are Task 1 and 2 and Task 2 has Task 1 as Predecessor task. Until Task 1 is marked completed, Task 2 or some of its columns are LOCKED and cannot be edited.
- Hey guys! I am facing some difficulty to get a formula for the logic below: Green Actual Start Date is blank AND Today () < Target Start Date Actual Start Date < Target Start Date AND status “in progr…
- I want to "Join" the data from one sheet to the other sheet in a Report using the Primary Field so that I only get 1 ROW with all the columns filled in. Instead, I get DOUBLE primary each with data po…
- Hi Can someone help me to write these five formula in a single formula to get the schedule health. IF(Status@row = "Not Started", "Gray") IF(Status@row = "On Hold", "Yellow") IF(Status@row = "Not Appl…
- Hi , Can anyone help me with this formula issue:- I have 4 symbol color- Not Started- Gray Not Applicable- No color On Hold -Yellow Complete- Green Act1 greater than Act2 and Status is equal to In Pro…
- I have a project with linked tasks. I can get the start date of the next task using the following formula: =MIN(COLLECT(Start2:Start6, Start2:Start6, >TODAY())) How can I return the task name associat…
