-
COUNTIFS FORMULA
Can anyone help where the error to this formula is please? Just trying to count if a date appears in one column and a color appears in another. Should be easy right? =COUNTIFS(({Range DATE CREATED}, DATE@row),{Range Colour}, "RED")
-
Populating the Parent Row from Another Sheet
I have a spreadsheet that contains all of the inventory information for a lot of products. These products are broken down into categories. For example, shoes (a parent row) would have the child rows of sneakers, heels, slippers. I am receiving orders from products onto another spreadsheet via a form. From the form, I am…
-
INDEX COLLECT, how to collect multiple values in a range when the criteria matches
My question is similar to another user's question name of the same name, however I could not recreate what the responder advised. One column I have "Week" which is represented by a date. In another column I have "Unique ID". In a third column I have "Comments". In a pivot, I summarize each Unique ID into one row but in one…
-
COUNTIF formula for age range help
Hello, I am trying to calculate age between 19-24. Below is the most recent formula I have tried but I keep getting Incorrect Argument Set. Can someone help? =COUNTIF({Adult Education CURRENT Roster Range 7}, "<19", {Adult Education CURRENT Roster Range 7}, ">24")
-
If Multiple Cells Are NOT Blank, Fill with "Pass" or "Fail"
Hi there, Trying to make a formula under my Pass/Fail column that results in a "Pass" if particular cells are blank but "Fail" if not. This is for quality control. So... this isn't working and I have tried numerous variations that work up until a certain point. =IF(OR(NOTBLANK([Complete - Critical Errors]@row, [Untimely -…
-
CHILDREN of two columns
I was trying to reference the children of two columns @row in a MIN(COLLECT()) function. Currently, I am only able to use two separate COLLECT() --- MIN(COLLECT(CHILDREN(col1@row, criteriaRange1, criteria1), COLLECT(CHILDREN(col2@row, criteriaRange1, criteria1)) But when I arrange the two columns together,…
-
Date formula help
Hi, I have a start date column and a complete date column. I am trying to track number of days since the start date (to today) that stops counting when the complete date column is filled in. If I use NETDAYS, it does not give me a count until the second date is filled in. Thanks!
-
Combining two formulas to filter data
I need to create a formula to count any lines that reference "GEMS Point", that will further filter only for any references within a given month. I have the following two formulas that are working perfectly: Formula for total by GEMS Point: =COUNTIFS({GEMS Point}, [Primary Column]@row) Formula for January programs…
-
#INCORRECT ARGUMENT SET on Index/Collect Formula
I'm building a dynamic dashboard with multiple filters. I'm making a Index/Collect formula that can read values on a source sheet based on the values selected via the filters. This formula should work and I've seen it work on other sheets that Pro-desk helped with, and they gave me, but for some reason, I'm getting a…
-
Text Join Formula
Hi there, I created this formula: =JOIN(Course@row) + " " + [Course Date]@row that worked but I need assistance on changing the order of it. Course Date with Parentheses around the date and Couse Name Formula that I have: =JOIN(" ", "(" + [Course Date]@row + ")", [Course]@row) that will not work Example what I want:…