-
Sheet Summary Average for last 180 days
I am trying to make a sheet summary that will give me the average of column "# of Days Open" if column "Date Entered" is equal to the last 180 days.
-
Average Resolution with Date
I have my average resolution for each ticket that is opened, and then i want to reach a summary sheet for each quarter that gives me my average resolution based on the quarter by month - i'm using my resolved date column so its in a date format. This is the formula that I am using, however i keep getting errors This gives…
-
countIFS/COUNT COLLECT
the first screenshot below is picking up the month number the stage is against the project name (primary column) pls scroll down the second screen shot below is my set up to try do a count function against month numbers I am failing to get the correct count function for this sheet im trying to make it dynamic rather than…
-
IF, CONTAINS, NETDAYS, AND, CONTAINS
Hi all, Trying to use a formula to work out net days between events in a column (Visit End Date) when a second column (Visit Description) contains "V" but also only if the last visit also contains a V. =IF(CONTAINS("MV", [Monitor Visit Description]@row), NETDAYS([Monitor Visit End Date]1, [Monitor Visit End Date]2)) worked…
-
Planned and Actual dates
Hello everyone, I guess (or hope) some of you have used the PMO template that contain these 2 columns, and then it calculates the overall "Health" based on the delay. However, I'm struggling with them and how to update them… Here is the scenario: Let's say that I just created my project plan, so it is easy to set the…
-
Countif Formula Addition - Exclude Value from Another Sheet
Hi all, I was wondering if anyone can help me and apologies if I do not explain this very well. I am trying to make an addition to an existing formula, to exclude a value from another sheet, but still count blanks. Current formula under 'Total Perm' column on main sheet: =IF(OR([Perm Promo]@row = "No available promo", [Max…
-
AI won't edit this formula
I need help to edit this formula to include only Designations with a Date of Manufacture (this is the column name) greater than 01Jan2025. I keep getting a request to regenerate the question. =COUNTIFS([Days btw Capping & Mfr Release]:[Days btw Capping & Mfr Release], >60, Designation:Designation, <>"PPQ1",…
-
Checking for duplicates between two different sheets
We are setting up a raffle where we will send out a form for someone to completed to enter the raffle. Once submitted we will take the (Full Name) column and randomly select a winner. We do have a few things on this sheet, we check to make sure there are no duplicates on the sheet, and once a winner is selected and checked…
-
When to use = and "" in COUNTIF formulas
I came across some weird COUNTIF functionality recently in one of my duplicate check column formulas. I wrote some exploratory formulas and wanted to share! Key Takeaways Numbers with leading 0s requires both = and "" Regular text requires "", but = is optional Regular numbers do not require = or "", but work with one or…
-
Distinct Numbers
Hello, I have a column "OPRO #" where it lists hundreds of OPRO # with many repeating number. I want to pull the unique numbers and list those in a separate column where each unique number has its own row. I am having issues finding a working formula. Thank you in advance for the help!