-
Current Month Formula
I keep getting an error on the below formula trying to COUNT for the previous month. I am reporting from two sheets, the live one and an archived version. This formula works fine until I add the current month requirement, then it throws up an error for #INCORRECT ARGUMENT: =COUNTIFS({Sales Pipeline Opportunity},…
-
Formula for RAG Status
Hello - I have a current formula that reads the following to show the Project Status on the left hand column as per the image below: =IFERROR(IF(COUNTIF(CHILDREN(Status@row), "Red") / COUNT(CHILDREN(Status@row)) >= 0.2, "Red", IF(COUNTIF(CHILDREN(Status@row), "Yellow") / COUNT(CHILDREN(Status@row)) >= 0.2, "Yellow",…
-
Absolute Reference
Hello, I created a column and am trying to have text from a cell always populate in all the cells with in the that column. Also when a row is added the text will populate in that new cell. I tried the convert to column formula but that brings in all the names from the column that that cell is in. I hope that makes sense. -…
-
Help Using COUNTIF with CONTAINS and the status column
Hi! I figured out the formula to count the row from another sheet if the cell contains a certain word, =COUNTIF({Current Project List Range 2}, CONTAINS("Events", @cell)) However this counts all the items regardless of Status. I'd like to get it to count only if the Status Column is also showing "In Progress" or "Not…
-
Health formula help
Hi - I'm sure lots of folks ask for assistance with similar things, so I apologize if this has already been asked/answered; I just haven't found anything to match my particular situation. I am trying to create an IF statement that will take into account multiple columns and conditions for a grant funding project management…
-
Help with CONTAINS Returning Invalid Data Type
I have the below formula to count if the department contains Facility and the dates are between January 1, 2022 and January 31, 2022. I am receiving the invalid data error. I have validated the Loss Date column is set for dates and the Dept column is set to text/number. =COUNTIFS(CONTAINS({Dept}, "Facility"), {Loss Date},…
-
Cross-sheet referencing to count across multiple columns for a matching row. Can't figure it out :(
I created a metrics sheet that references my G-List sheet. In my metrics sheet I'm essentially trying to say, "Look at the matching [Ops ID No.] in the portfolio sheet (G-List) and count the number of cells across multiple columns that have no dependencies indicated (i.e. ="None")." The common column in both sheets is [Ops…
-
Accurately Count if Multiple Contacts are in a Cell
Hi, I am really struggling trying to map out certain data points, when it involves our sales reps, because we can have multiple contacts in a single cell. In this particular instance, I want to find out how many quotes a sales rep has issued this year. Problem is, multiple sales reps can quote the same job, so another…
-
IF/Index/Match
It's Monday and I can't seem to get this one to work. If a value populates in a cell in a specific column (this is a formula column) Every row that contains this data (All the columns) it would fill in the data that's listed in the formula column.
-
Create a sheet that lists all working days in the date column
I am creating a template for a daily log for our job sites. I want to find a quick way to fill in our working days into the rows so I'm not manually typing or clicking and dragging and deleting every weekend day, does anyone have a formula for making this happen?