-
Count if date is in the last six months
I'm trying to refine my metrics for the number of Packages archived in the last year. This formula (which is working correctly across two sheets)... =COUNTIFS({Package Status 1}, CONTAINS("Archived", @cell), {Package Type 1}, "HWMP") + COUNTIFS({Package Status 2}, CONTAINS("Archived", @cell), {Package Type 2}, "HWMP")β¦
-
COUNTIF greater than or equal to?
Hello, I am trying to find the number of entries that are greater than 0 but are equal to or less than 2. Many of the results in the data source column are in decimal form. for example 1.38 etc. The formula I have now either does not recognize the decimal result or I get an #UNPARSEABLE error. I seem to be missingβ¦
-
How can i manually enter range values in a formula
I would like to manually enter a list of values in the range parameter for an INDEX formula, as follows: = INDEX (range , row/col number ) = INDEX ( {"Jan";"Feb";"Mar"}, 2 ) = "Feb" In this example, I don't want to have a list of month abbreviations somewhere else on the sheet, or as an external reference to another sheet.β¦
-
COUNTIFS isn't working
Hi I am trying to count all the number of 0s within a column. I am using this formula =COUNTIFS([Warranty Remaining]:[Warranty Remaining], 0) but it does not work. What is weird is that, I changed the formula from [Warranty Remaining] to count a specific number in the [Warranty Obligations] column and it worked fine. I'veβ¦
-
Reference Formulas in Templates
Hello, I have created two templates from sheets that reference each other in a SUM+DATE formula. I would like the new sheets created by the template to reference each other, but at this moment they reference the old sheet from which the template came and need to be changed manually. Any way to achieve this? Thanks inβ¦
-
#INVALID VALUE or empty cell when using INDEX MATCH formula
As you see in the screenshot when using the formula below, it worked perfectly in the first column (Interim Handover Letter), however, it started to give me either (blank/empty cells) and (#INVALID VALUE) when applying it to the rest of the columns. I'm trying to return a value from (column number 12) a reference sheet byβ¦
-
INDEX/MATCH formula has me stumped
I am trying to understand a formula that someone else has written and I cannot get it. It works great but I do not know how and I would like to. It looks like this: =COUNTIFS(INDEX({EDB Full Range}, 0, MATCH([Equipment / Limit Required]@row, {EDB Full Range}, 0)), >[Equipment Max#]@row, {EDBDate}, >=Start@row, {EDBDate},β¦
-
Returning Text if JOIN(COLLECT(...)) unable to make a reference
I noticed that, if JOIN(COLLECT(...)) is unable to make a reference, it just returns null. I am drawing a blank. How can I cause it to return text instead?
-
Dashboard from Metric Sheet
Hello, I am having trouble with a Dashboard metric. I have set up a widget that display tasks per assignee, and thus created a metric sheet with several potential assignees. The widget is not showing all rows with value. please help
-
I'm having problems creating Google/sheets to capture hours/minutes for 20 CERT members.
CERT (Community Emergency Response Team) is group of volunteers working for city fire dept. I have a Google/sheets to capture individual start times (military, no colon), end time (same), and duration time. At the bottom of the column, I want a total hours to submit for insurance purposes. I want the 'duration time' columnβ¦