-
#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:…
-
SUMIFS excluding criteria
I am trying to sum the amount awarded to programs that have been won by all clients except Client X, Client Y or Client Z but my formula below is coming up #UNPARSEABLE. What am I doing wrong? =SUMIFS([Amount Awarded]:[Amount Awarded], [Customer Name]:[Customer Name], <> ”Client X", <> ”Client Y”, <> “Client Z”,…
-
Multi-Select Formulas
First.....Im so happy the Multi-select feature is now available - so thank you. This leads me needing some assistance. I have played around with a LOT Of different formulas trying o find a way to capture this information. I am needing help with trying to find a formula to do a count of selected options that were placed in…
-
Checking a box in a sheet when searching a person and if they are checked in another sheet
Hello, We have a data input sheet where we would like to signify who are key personnel using a checkbox (star). In the data input sheet, we have staff names (Person) as well. We also have a rollup sheet in which I would like to have a box checked if the staff (Person) is checked in the data input sheet. I know I need to do…
-
Formula for Parent/Child based on how it is answered
Hello, I am trying to use a formula that can be used for data validation. So if a grandchild is selected as "In Review" but the other grandchild rows are still in "Not Reviewed" I want the child and parent to reflect that overall section as "In Review" How would I set this up? I know I can use the =SUM(CHILDREN()) for…
-
Formula
I Have a sheet that collects, via form, all the diesel issued to our equipment. I have a column that needs to look at the previous hours for the specific equipment number, but my formula only looks 1 entry back, and should continuously look back. My formula looks like this; =INDEX(COLLECT([km/Hour]:[km/Hour], [Job #]:[Job…
