-
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…
-
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…
-
IF formula to calculate points
I'm trying to create a formula to calculate points and I can't seem to get it right. This is what I have: =IF((Occurrence@row = "Tardy", 1), IF(Occurrence@row = "Late", 2), IF(Occurrence@row = "Half", 3), IF(Occurrence@row = "Full", 5),0) Basically, if the Occurrence column has any other those, each is worth a specific…
-
If bringing numbers into Sheet Summary by a formula - need to be able to make less then 0 Red
If using a formula to get Sheet Summary data - for numbers, need to be able to make less then 0 Red