-
automating image display in a dashboard
One of my stakeholders is a big fan of visual information, and when viewing a dashboard, has asked for quick, visual way to assess the project health. I have a tentative formula for calculating that health (=IF(((COUNTIF([Risks?]:[Risks?], 1) / COUNT(Tasks:Tasks)) / 100 <= 0.1), "low risk", IF(((COUNTIF([Risks?]:[Risks?],…
-
Horizontal Dates with Index Match
Having trouble with an Index Match function. I have the Match portion working, but not the Index. Goal is to display the name of the current stage. Yes the three Stage columns and "Index(Match)" column are set as Dates. I have the Stages backwards since the Match function reads left to right and some Stages might be…
-
Data one one line
Hi, I have the data across multiple columns how do I have it all on the main parent level. I would like to build a report that includes it all but having issues since the data is in a different row. Then I need to be a formula so it auto calculates going forward since the data will be dynamic
-
I'm having trouble with a formula
I want to count the number of Unique Programs when Project Status = Active and Department = Professional Services Based on my example I should get the count of 4 I have tried several combos of COUNT and DISTINCT but may syntax is all wrong
-
Restrict number of times date is allowed to generate?
I am looking to formulate a column to generate a date based on the submission date and turnaround time of the type of task. However, we only want to allow each date to generate up to three times. If that date reaches a fourth date, then we want it to add a day to the generated date. Example: Doc1 received on 2/24,…
-
Inactivate a task
Is there a way to make a task or group of tasks inactive in a project plan? In Microsoft Project there's a function called Inactivate that's used after you select tasks that you want to make inactive. Doing this does not affect resource availability, the project schedule, or how other tasks are scheduled. I know this…
-
Formula Help - Cross Reference Sheet
Hello, I need help solving this issue that is stumping me. To goal of the cross sheet reference formula is to highlight which employees are no longer with the company. There is logic in place that when the name contains "TERM-", a column will be checked to help indicate to exclude from reports and counts. However, as shown…
-
Adding Minutes to a Time value
I am creating an event sheet, with time information as follows: Setup Time Needed - values will be in 30 minute increments (30 minutes, 1 hour, 1.5 hours, 2 hours) Requested Start Time - values will be in 30 minute increments starting at 8:00 AM to 9:00 PM Requested End Time - values will be in 30 minute increments…
-
#NO MATCH on MIN/COLLECT function
Hi, I am setting up two very similar sheets, with the same columns and similar data (each sheet is for a different date range). In both sheets, I have a column that uses a MIN/COLLECT function to detect duplicates when new rows are moved into the sheet. The formula works in one sheet, but in the other, it returns a #NO…
-
Average of 1 column based on 2 other columns
I am looking to find the average of my KPI Calculations column based on the Go-Live Quarter and the Team. I can get it to work for 1 column but not 2 =AVERAGEIF([Go-Live Quarter]:[Go-Live Quarter], "Q1 2025", [KPI Calc]:[KPI Calc])