-
Formula Help
I need a formula that pulls the data from the column if that cell is not empty. (Ex; If 1 is empty but 2 is filled, pull data from field 2). As-Built Production Yield Final Production Yield 90% Production Yield 60% Production Yield 30% Production Yield Total Production Yield Target My current formula is below but it does…
-
IF formula returns unexpected TRUE result for text cells that start with the < or > character
I have text column in one of my sheets named EN Display Name. That column cannot contain duplicate values, so I added the formula below to a helper column in the sheet to make it more obvious when multiple rows had the same value in the EN Display Name column. =IF(COUNTIF([EN Display Name]:[EN Display Name], [EN Display…
-
Help to avoid hundreds of conditional formatting
Hi all, I have a sheet with columns that list a particular service. My rows are site names and we're tracking the level of adoption for each service with the below list: FI (H) FI (NR-H) FI (NI) C-FI P NI V N/A I want to have each one colour coded like you would with conditional formatting but I have 28 columns and so if I…
-
COUNTIF Formula with 2 Criteria - Status & Checkbox
Hi, I am trying to create a summary sheet from a detailed project schedule and would to create a COUNTIF formula that adds to the countif sum if the row status column is "complete" and the internal milestone column is checked; however, I am receiving an #UNPARSEABLE error and not sure what the issue is. Here is my formula:…
-
Trouble with join/collect or index/match, with multiple columns and multiple results
Hello, I can't seem to get this right and after too many hours on this, I am escalating it to the formula masters of this great community once again. I am attempting to create a cell that will collect and join all the matched criteria from two different columns with the same criteria. There are multiple matches in both…
-
#Invalid operation error for summing values
Hello Team! I have a weird case, but let's go straight to the point. I have a simple formula: =SUMIF([F Tracking ID Number]:[F Tracking ID Number], [F Tracking ID Number]@row, [X ASIN Value (CI)]:[X ASIN Value (CI)]) which basically sums values from column X for duplicate values in column F. The formula works fine for…
-
Date Match from another sheet
I'm trying to populate a date cell from another sheet. I used this fromula to find Names and it worked. I'm getting NO MATCH. I think it has to do with it being a date? =IF(COUNTIFS({SHIPPED JOBS Root Job}, [Root Job]@row) + COUNTIFS({TRUE SOURCE Root Job}, [Root Job]@row) = 0, "Job Number Not Found", IF(COUNTIFS({SHIPPED…
-
COUNTIFS formula question
I'm trying to count items on a sheet if they meet a certain criteria and contain a name and put that value on a different sheet. I'm using this formula =COUNTIFS({MT Rollup Sheet IT Lead}, CONTAINS($Label@row), AND {MT Rollup Sheet Project Status}, "Active") and receive an UNPARSED error. I want to count how many active…
-
How to pull the top row only to sheet summary
What is the best formula to pull the top row only from the sheet I am in to the sheet summary fields?
-
COUNTIFS with 3 ranges
I am creating Dashboard Metrics based on Status information in a sheet. The sheet has a Status Column, Parent Status Column and a helper Column "Parent" that is Zero if it has children records or if it has no children records. If I use the below formula, my result is 2, which is correct for the "Status" column:…
