-
Using COUNTIFS with CONTAINS and OR
Hi everyone, I have been trying to create a pie chart in a Dashboard by referencing another sheet which has cells with multiple values from a dropdown, so that I can count the number of cells that CONTAIN some of the values. I've been trying to use the OR, so that it counts the boxes that contain any of the values, but I…
-
Can I use Join(Collect with multiple entry drop down?
Hi, I have a formula below that looks at 2 sheets and when the "PLY-Code Needed" from the 1st sheet finds a match on sheet 2, it gives me the "Description" from sheet 2. It works fine but as shown in row 131, there are 2 "PLY-Codes" and this makes this unable to pul the info. Any advice? Here is my Current formula:…
-
Formula help
I am counting assigned cases by month with this formula and getting an #incorrect argument error. Any suggestions on this formula. As you can see I have a helper column on the source sheet to reference the month: =COUNTIF({2025 Corr Officer Tracker_ BI Investigator Assign}, "Brian Blocher", {2025 Corr Officer Tracker_ BI…
-
Column Formula
Is there a way to break up a column formula after a certain number of rows? We have an inventory column that is broken into 2 sections which are divided by a row. For example: I'd like the first 100 rows to be one formula and the next 100 to be a different formula. I want to use a column formula instead of manual entering…
-
Index Match with a multi-select dropdown
I am trying to write a formula that looks at a multi-select column to pull email addresses from a reference sheet. With my current formula it only works when there is one value in the multi-select column. =JOIN(COLLECT({Reference Sheet | Contact Q2}, {Reference Sheet | BID}, HAS(@cell , [Sites to be included]@row )), "/")…
-
Formula to check a box if a PARTIAL string is present in a specific cell in a descendant row.
Hey Folks! I have a working formula to check a box in a parent row if a condition is met in a descendent row. In this case, if the row "Type" is "Action Item". This is working and the formula is as follows: =IF(COUNTIFS(DESCENDANTS(Type@row ), "Action Item") > 0, 1, 0) This works well because the cell type is a drop down…
-
Question about Formula
I am working on a request form, I had a link to an inventory sheet. Is there a way I could have the requested value turn a specific color if it is greater than the inventory value.? Also is there a way I could link a whole column to one cell in another sheet without having to individually do each cell?
-
Decreasing a set number when a name appears
Hello! I am trying to create a formula for assignments where I can set a number (3), and when a name appears in a sheet, that number decreases for each time the name appears. I also currently have a formula where I have the number of times a name appears / 5 (we have 5 days of the week displayed each week so while the…
-
Creating a tailored drop down list in a column based on the value in another column.
Example - Risk Log. I want to be able to create dynamic filtering of a dropdown column "Sub-Category" based on the value selected in the Name/Number "Category" column. I've seen this done in Excel using the combination of: Excel Functions: INDIRECT() – to reference a named range dynamically SUBSTITUTE() – (if needed) to…
-
Automatically populate a new row in a report that contains formula references to a master sheet
Hi, I am struggling to find a solution to something that should be straightforward, I think. I want to create a dashboard that plots (1) summary values from a master sheet extracted every 2 weeks. Alternatively, I thought I could plot these values from a helper sheet that contains the same formula with a cross-reference to…