-
Condition
Hi there. I have a sheet with so many rows and columns, and I want to set a condition where if some specific fields are not blank, then that field will be highlighted. I managed to do that, but it seems like i can only set one column at a time. Is there a way to set that condition throughout the entire sheet, not just…
-
Need to get the last not blank text value in a column
Hi, I have an inventory sheet with transactions of check-ins and check-outs. So far it has just been collecting the quantity of checked-in and checked-out to get the overall in stock quantity. Transactions are done via a form that input a new row into bottom of the sheet, with count numbers being updated at the top. This…
-
I need to collect the average of a column by referencing name in another column
I have columns in a sheet per the screen below. The Team Member is input through a form submission and can potentially be input many times. I am looking for a formula to collect the average score from all rows where one name appears without having to say ="Scooby Doo".
-
Use COUNTIF with AND to add additional count conditions from other columns in same sheet
I want to count the number of times a certain parameter is assigned a certain category. I have 3 parameters that I track "incidents" for: HG, PM and SO2. In my summary sheet, I want to count the number of times in the sheet each parameter is assigned the EPA Downtime Category: "Monitoring System Malfunction" for use in a…
-
Nested IF And/OR statement
I am trying to create a formula that will give me something similiar to the below: If (A1=A) and (B1=A) and (C1=A) then (D1=A), If (A1=D) or (B1=D) or (C1=D) then (D1=D), Otherwise D1=S
-
SUMIFS Issue
I have a fairly straightforward formula that i cant get to work, driving me crazy! I typically prefer Sumifs over Sumif but currently I am summing a kpi column of numbers if two additional columns (both Text/dropdown (single Select format) report a specific set of words. what am i missing!?! Thanks in advance. =SUMIFS([KPI…
-
Date Formula
Good morning! I need help with a date formula (highlighted). It's counting but not the total where the start date is in the next 7 days. You can see the sheet summary fields as I want to use the "7 days out" as a metric on a dashboard. If I replace the range1 to a unique column, the formula returns zero...I'm confused.…
-
COUNTIFS with Multiple Date Fields
Hi all, I'm having some issues with a formula concept. My management wants a year to date view on various Phase Status within a Project Portfolio. I am trying to figure out, with dynamic figures how to get YTD on projects and settled on using all the various date fields as maybe an OR Function. I'm not sure if this is the…
-
if / or / contains
Hello, I need some help with a formula using if / or / contains. If the cell contains "card", return the words "Business Card", or if the cell contains "page, return the words "1/4 Page", otherwise keep blank. I can get part way there: =IF(CONTAINS("business", [Spring / Summer Newsletter Ad Size]@row), "Business Card", "")…
-
Summary Report Capturing Data From Child Row
I have been tasked to create a status update report each week, showing which projects have not been updated in 6, 4, and 2 weeks, from Wednesday of the current week. The column where I need to pull the data from has the following hierarchy: Each Wednesday, I have to drill down the project parent, and then the child of the…