-
The sum of values in the next row
Hello everyone, I'm having difficulty writing a formula and would like to ask for your help. If in the fourth column of the image below, a risk condition has been identified, I would like to sum the values below the row where the risk was identified, without including the row classified as a risk in a new column right…
-
What am I doing wrong in this formula?
=IFERROR(INDEX(COLLECT({Master Unit/Manager List WI Range 1}, {Master Unit/Manager List WI Range 2}, [Site]@row, {Master Unit/Manager List WI Range 3}, [Department Name]@row),[{Unit/Manager List WI Range 4})) My goal with this formula is: if SITE and DEPARTMENT Name on Sheet1 matches SITE NAME and DEPARTMENT NAME on sheet…
-
Count is not blank
I am creating a sheet summary. I would like it to count only those in January and my column range cells are not blank. I feel like I am so close. =COUNTIFS([Audit Month 2]:[Audit Month 2], "January", NOT(ISBLANK([Test Issue 1]:[Test Issue 4])))
-
Row Report Custom Filter: Allow Basic Formulas to used to Filter Data
Current Build: When Creating a row report, you can filter by Column data. Example: "Month = 3" or "Percent > 75%" Concept: I want to be able to apply basic Formulas to custom filter data. Example: Month =Today(-31) or Percent > AVG([Average1]@row, [Average2]@row) This would reduce the amount of times you would need to…
-
There has to be an easier way...
Hi smarties, I have 40 metric sheets (one per location). In each sheet I have an countif formula that references a data sheet. I have this formula in about 20 columns. A sample is in the screen shot. It says something like count if the name in the Frontline leader column of the metric sheet matches the name in the data…
-
Cannot create "Net Days" column formula
I have a column that auto-populates the number of days left between now and a project launch date. =NETDAYS(TODAY(), [Effective Date]@row) is the formula that I have in the column, and it works when applied row by row. It will not allow me to make it a column formula. Why not?
-
How to hide #DIVIDE BY ZERO error message
Hello, I am looking for help utilizing a formula to hide the #DIVIDE BY ZERO error message. My current formula in the "Change" column is simple: =([Availability %]@row - [Previous Availability %]@row) / [Previous Availability %]@row But for any cells in the "Previous Availability %" column that have 0%, I get the #DIVIDE…
-
Removing commas if a field being joined is blank?
Have a "Reason for DQ" field that aggregates responses from hidden helper columns (finds fields with "bad" conditional formatting). What it looks like unhidden: I'm so close...but so far...how do I keep the commas separating data but remove them if the fields are blank? Forumula being used below: =JOIN([Pre-Bid…
-
Formula to Join Cells that have Content (with Line Break)
Looking to see if there is a formula that would allow me to join cells into separate lines ONLY for cells that have content. Essentially I want to remove blanks somehow so it is just seamless data. In my example, when I use CHAR(10). It joins the cells, but leaves blank lines if nothing was filled in for a cell. Im…
-
Formula =COUNTIFS ... to not include certain text
ok almighty people..... I currently have =COUNTIFS({Depots1}, [Column1]23, {Product1}, FIND("Other", @cell) > 0) This counts cells that depot is = column 1 row 23, if the product column contains the word Other (product column a multiple select cell, with free type option) However I want to count cells that depot is =…