-
How do i create a calendar within forms that will block off certain dates?
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 able to have about 10 people sign up for, so that date will need to be crossed out once that limit is reached.
-
How to create this COUNTIFS with AND/OR/NOT
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", @cell <> "Complete"), {(Phoenix) Project Tracker - Status column}, AND(@cell = "Complete"), {(Phoenix) Project Tracker -…
-
Formulas for % Allocation in Resource Manager
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? I've done quite a bit of research on it and haven't found a straight answer yet, but it seems as though having a formula…
-
Enhancement Request: Ability to lock a row if if a task is dependent upon another being completed
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.
-
Project Health Formula
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 progress” Yellow Target End Date – Actual End Date >=0.1 * Duration planned AND Target End Date – End Date <=0.3 * Duration…
-
Can I use a Join when trying to create a report from 2 sheets
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 populated only from the Sheet it came from which isn't useful at all. Is this possible?
-
Formula issue
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 Applicable", "") IF(Act1@row >Act2@row , "Red") IF(Act1@row <Act2@row , "Green") THanks
-
Formula not working
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 Progress - Red else Green =IF( Status@row <> "Not Applicable", IF( Status@row = "Not Started", "Gray", IF(Status@row = "On…
-
Return task name associated with a future date
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 associated with this upcoming task? In this example, this formula gives the next start date as 6/19/19. What formula will return…
-
Formula for Actual duration excluding duplication
Hi Community, I am trying to calculate the actual duration starting from a list of Start and End dates. What I am trying to achieve is to exclude duration overlaps in order to get the actual effort days only, but including not contiguous time ranges. Please see example: Start: 01/10/2019 End: 04/10/2019 = 4 working days…