-
Multi-step formula help needed
What formula could I use to count how many GWS divisions are in progress during the year 2022? This is the formula I have but it is not working. Thanks in advance for the help. Dina =SUMIF({Helix Migration Plan Range 3}, 2022, (SUMIF({{Helix Migration Plan Range 5} ,"In Progress",{Helix Migration Plan Range 4}})))
-
My formula isn't quite right to be able to convert to a "column formula" What is wrong with it?
=IF(COUNTIF([Apr 15 @ 6:40]@row:[Last Deploy]@row, ="Area 2") > 0, COUNTIF([Apr 15 @ 6:40]100:[Last Deploy]100, ="Area 2"))
-
Check a checkbox with 2 criteria
I have 3 columns: Action Plan Move Row (checkbox) Helper I need to check the box if the following is met: 2 exact values in the helper column. If the Action Plan is empty. Check the checkbox in the row with the empty Action Plan. I keep getting an error using this formula if the Action Plan is empty (2nd line):…
-
Formula Assistance
I'm struggling to pull a particular formula from my data source sheet into my metrics sheet. My criteria is to Count If: Submission Request is "Manager Change (Talent Only) Talent columns #1-10 are not blank Submitted Date is between August 1 and August 31 I've tried several things. The last effort being the below formula:…
-
Formula Assistance
I'm struggling to pull a particular formula from my data source sheet into my metrics sheet. My criteria is to Count If: Submission Request is "Manager Change (Talent Only) Talent columns #1-10 are not blank Submitted Date is between August 1 and August 31 I've tried several things. The last effort being the below formula:…
-
Easiest solution I have for (time)-(time)=duration
I always look here for solutions to my ideas before I spend too much time on them. I was not able to find a simple solution for doing calculations with time. Honestly, after my initial search, I ended up exporting to excel to do the math, then importing back in. Long story short, here is a single formula to subtract start…
-
Nested Formulla
Hello, I am trying to create a formulla, perhaps with IF(AND). I have 4 columns. Each column with the following dropdown: Yes, No, Sometime, N/A. The columns are: Criteria A Criteria B Criteria C Criteria D What i need to happen is the following: If criteria A to B are all "yes", then the overall answer should be "yes" If…
-
IF INDEX MATCH function has circular reference
Hello all, the following formular gives me a #circular reference mistake. Based on the below can anyone see already why this might be th case? =IF(INDEX({Vertical}, MATCH([ERP Item Number]@row, {ERP Item Number}, 0)) = [CHECK Vertical]@row, "TRUE", INDEX({Vertical}, MATCH([ERP Item Number]@row, {ERP Item Number}, 0))) Let…
-
How do I determine the number of top-level rows in sheet without a helper column?
Hello, As part of a larger formula, I'm trying to determine the total number of top level rows (rows without parent rows) in a sheet. My goal, is to do this without the use of a helper column. None of the formula's I've tried have worked, and I'm starting to think its due to a misunderstanding on my part or a lack of…
-
Move Rows Not Working
I have a form tied to a sheet that tracks Name, Work Email, Hire Date and dates for various Safety Credentials. In this Source sheet, I have a formula to track if the person's Name entered into the form is unique. If it is unique, I have workflow that moves the entire row to a Destination sheet. Everything works, except…
