-
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])
-
Using the difference between dates in an IF statement
I have a column the calculates the number of days between 2 dates, which is fine. =[Arch Prelims]@row - [FP Arch Engagement ]@row (gives me a number) But I don't want to do the calculation if the difference is a negative number. There are few instances where the result would be a negative number (very few) I don't want to…
-
Formula Query - Nested IF Statement
Hi, i have a problem where i am tendering on projects, where i request quotes, input the prices, then i will adpot the price i wish to use that makes up the total. Im struggling to get the formula right. Basically it should be the Quantity x Rate, unless it has children and the "star icon" is checked, in which case it will…