-
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.
-
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…
-
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!
-
Pre-Filled Forms Using URL Queries: Tips and Tricks
Using URL queries to pre—fill forms seems to be catching on a bit more lately. There are a lot of resources out there, but they can be kind of spread out, so I figured I would start a thread that has some of the lessons learned, tips, and tricks that I have discovered along the way. Tip #1 The first one that I find makes…
-
Help! Need to match a cell between two dates with complex conditions
Hi, I have a complex formula that i cant seem to figure out. I'll do my best to describe this below In Sheet 1 i have a unique identifier whose condition changes from blue to green after a certain date Unique identifier Condition StartDate EndDate 123456 Blue 1/5/2025 31/10/2025 123456 Green 1/11/2025 I want to ensure that…