-
Need to update dates to Q1_2025, Q2_2025, Q3_2025, Q4_2025
I need to update a value in a new column. How would I look at a date column that shows dates between 01/01/2025 to 03/31/2025 and place the value of Q1_2025 into another cell?
-
Trying (without success) to use a contains with a Countif when referencing another sheet
When I try this statement: =COUNTIF({PM Assigned}, [PM Name]@row) I get the number 55 - which is correct. The number of cells that EQUAL that value are 55 BUT I am looking for the number of cells that contain that value (Should be 56), but I have had zero luck with all of the combinations I have tried. Any help? To state I…
-
Need to reference distinct values from another sheet
I'm looking for a formula to automatically pull distinct values from a column in another sheet to use in a reference sheet. Example: Source sheet 1 has a list of [CustomerID] and various other columns. Some [CustomerID]'s are listed on multiple rows. Reference sheet 1 wants to list all the DISTINCT([CustomerID]) values, so…
-
Can I pull in information from one sheet to another when there are multiple matches?
I have a budget tracking process I would like some help setting up. See steps below: Employees fill out a budget request form for office events. On this form, they state the name of the event they are hosting, which office they represent, and how much they are requesting from a pot of funds. This is stored in the Primary…
-
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…