-
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
-
Formula for counting total of a specific word in a parent column only (not including child)
Hi everyone, Is there a formula to count the total rows of a parent row (instead of making a checkbox section for parent row)? Need help with this the most: Is there a formula I can use in summary sheet that can help me find the total count in a different sheet for a specific word (Ex: "NC", "FCAR", "total of all the…
-
Can someone please help me with SUMIF formula?
I am trying to use a formula that will add value in children cells when cells do not include an asterisk in front of the value. Basically, I am creating an invoice tracking spreadsheet and I want to be able to input expected monthly invoices (based on the contract) on the front end, but not have those values added to the…
-
Index Match another Sheet
Hi there, I need help with structuring this formula: =IFERROR(IFERROR(INDEX({Program Duration}@row, MATCH([Program Name]@row, {Program Name}@row, 0)), INDEX({Program Name}@row, MATCH([Program Name]@row, {Program Name}@row, 0))), "") I want to index match column information to another sheet. The column names are the same…
-
Stacked Bar Chart Data Sheet
Hello I am trying to create a stacked bar chart based on the following: I have a multi-select dropdown column, so there may be more than one value in it. I then have a second column with Priority listed. I have created a sheet that calculates how many times each drop down is used but I want to know how each drop down…