-
Sum child rows that use a formula?
I have child rows that use a formula to calculate % completion based on input to another column. I'd like the parent row to return a value based on the child values (Specifically, sum of the child rows divided by the number of child rows). As the child rows use a formula rather than a direct number entry, entering a…
-
Count # of Parent Rows in a Sheet
This seems like such an elementary question but I keep going around and around on this and I can't find what I'm doing wrong. I'm trying to count the number of parent rows in the sheet (each parent row represents an "Employee Name"); I want to include this count in the sheet summary but I can't seem to figure it out. This…
-
COUNTIFS FUNCTION WITH EMBEDDED CONTAINS FUNCTION
I have been looking at the various conversations on using a COUNTIFS with an embedded CONTAINS function, but have had no success getting it to work. In the below formula I want to count "FAA Domestic" and recommendations that aren't closed (0) if they contain an assigned office that contains AIR-62. The below formula…
-
How do I utilise the IF formula to allow a T-Shirt size to be generated based on duration of days?
Hello, First time asking a question. Forgive brevity/waffle! I have been struggling to understand the syntax issue I have when trying to generate a T-shirt size based off the 'Duration [Days]' column I have. If 'Duration [Days]' is known/calculated from START/END Dates can I generate the t-shirt size automatically? My…
-
can't get this formula to work correctly -- adding a check box if contains
Hi all, I have a box with a dropdown menu with 3 options but you can put multiple items into the box. The dropdowns are GPA PACE Max Time Frame I have 3 columns check "gpa" check "pace" check "Time Frame This is a sample formula there is one for GPA and PACE =IF(CONTAINS([SAP Issue]@row, "Time Frame"), 0, 1) I want the…
-
JOIN only if cell is not blank
Hi there, Is there a way I can use the JOIN function to merge the contents of an entire row from another sheet, but exclude rows that are blank? The contents of the other sheet is generated from a form (and being constantly updated), so referencing the entire column is the only option unfortunately. It seems like it should…
-
Background auto-refresh a sheet as frequently as every minute.
This might be my first real contribution to this community, but I think I have had a breakthrough with respect to background auto refreshing a sheet. I've seen the common solution of utilizing a workflow to trigger a daily update of a date column, but the challenge has always been that you are obviously limited in how…
-
Sheet summary formula becomes #unparseable upon sheet exit
Hey folks, I'm hoping you can help me solve a mystery. I have about 30 sheet summary fields all using the same formula, which counts two types of responses in each column. I copied and pasted the basic formula in every sheet summary field, then changed to the appropriate column name (the column names are spelled…
-
How to review a column of dates and count the rows that are not a date
I have a use case where I have a list of dates and need to count the number of rows that do not have a date in the column. For example, 12/01/23 12/02/23 12/03/23 Active 12/05/23 Not Active 12/07/23 (space or blank) 12/08/23 12/09/23 12/10/23 In this example, the number of non-dates in the column should be 3. I believe I…
-
Struggling to String together the correct COUNTIFS
Hello There Community I need help with stringing variables together I am using the following formula: =COUNTIFS({GDS}, "Sabre", {Status}, "Open", {Airline}, (CONTAINS ("AA", (OR ("ALL"))))) Everything works up until {Airline} which is the sheet reference Essentially I want to return the count if the cell contains either AA…
