-
Counting from a reference sheet - Don't show Zero Count
Hello All, Is there a way to NOT display "0" in my calculation sheet when counting items from another sheet? Here is my current formula: =COUNTIFS({DWR}, "Green", {Week}, [Wk1]$1, {Shift}, $Shift@row, {Crew}, $Crew@row) / 48 When this is "0", I would like the cell to be blank so it is not calculated in my averages.…
-
Formula to capture overall health of projects on one sheet
Hello, I'm looking for a formula to capture in the Portfolio Health when the Overall Health status changes. I would like the formula in the Portfolio Health cell to show Green when all Overall Health cells are Green. When one Overall Health cell changes to Yellow, the Portfolio Health turns Yellow, and when there are 2+…
-
INDEX/MATCH is not pulling one value
Hello, I'm completely stumped by this. I have a column formula in Column A in Sheet X with INDEX AND MATCH. It is pulling every value from Sheet Y perfectly fine except for one: I've double checked on both Sheet X and Sheet Y that there are no extra spaces or other weirdness in the company name on either sheet. They match…
-
Counting Blank Cells
I need assistance on counting all rows that are blank based upon a status column The formula I used is: =COUNTIF({Status Blank}, HAS(@cell, "--")). and I tried using this formula: =COUNTIF({Blank Status}), ISBLANK(@cell)) The "Status Blank" is referencing the other sheet.
-
How do I change when my Sheet starts the next workday?
I have a formula in Sheet Summary that counts workdays remaining until launch. It works except that the count doesn't go down each day until 10 AM. If anyone looks at it before 10 AM, it shows an extra day. I can't figure out why it updates at 10 AM, so I don't know how to fix it. Ideally, it would change at midnight.
-
Average of Column
Hello! I was wondering if anyone knew of a way to get an average of a column. I know we can get an average of a specific range in a column, however this sheet I'm working on is a survey and there will be ongoing entries. If possible I just want to get the average of the whole column so I don't have to come back and update.…
-
Multi Criteria Formula
I need to create a formula that filters rows based on several criteria. The formula should show rows between specific date periods for the ‘Date Created’ and ‘Date Closed’ columns. For example, rows created between 01/01/23 and 02/01/23. Next, the formula should break those rows into counties based on the ‘County if…
-
How to turn off Harvey Ball from showing in blank columns?
For existing rows that have the "none" clicked in the Column with a harvey ball symbol, it doesnt trigger the check mark or grey ball to go away in a blank row. And it wont let me manually turn it off either since the formula is in there. I would like for these two columns(risk and done) to be empty when there is no date…
-
Count if with multiple criteria
Hi all, I'm trying to get the count of a specific Call Outcome in a given month. I've tried =COUNTIF({Call 1 Outcome}, "No Answer") and =COUNTIF({All Calls}, "No Answer") to get the total count however when I add a second condition i.e. =COUNTIF({All Calls}, "No Answer", {All Calls}, "Nov") it given an error. I'm trying to…
-
Countifs and Or Function
I am attempting to use the countifs function to assess how many requests are in a critical status, but are also not completed, canceled, or otherwise not active. Those statuses are: "Active Sprint", "Backlog", "On Hold", "Sprint Assigned", "New". This formula works and is referencing the "Critical" requests that are in…