-
Count cells within a column that are not blank
Hi all, trying to work out a formula to count how many cells have an entry (number or text). Can not find a formula for "is not blank". Please help.
-
Using If and Index Match across multiple sheets
I had to break down two cross sheets due to the size of data. I created another sheet with a form. I would like to have an index match formula that if a name was found at the row, it would cross-reference the sheet tied to where that data is store and return a value. This would eliminate the need to pivot into that data…
-
How do I make a nested IF formula check another cell as Priority to change status of another cell?
Hello, let me start off by saying any assistance available is greatly appreciated!!!! In our work schedule we use parent child hierarchy. Through the use of other community discussions, I found a formula that I could modify and use that would change the status of the parent row based on the overall statuses of the children…
-
Replacing rows with automation
I have a sheet where I automate importing new rows whenever there is a change in spend. I want it to replace the previous row(s) that was imported with the same placement name so only the most recent one is visible. I'm thinking of some kind of formula that would populate on rows that have the same campaign name as other…
-
If Statement Help
Three conditions to meet the result. [Name] to match with another reference sheet with [Full_Name] from other reference sheet: PayerAbv = "B" from other reference sheet: Effective Date = Not blank return "Yes" or "No" =IF({Full_Name} = [Name]@row, {PayerAbv} = "B", {EffDate} <> "", "Yes", "No")
-
pulling data from multiple columns at once
I have a master equipment sheet with different projects on it. I'm using a form to collect the information from the lightest orange fields because it's the easiest option for my auditors to use when they're in the field. I would like to get that information back to the original sheet. I know I can use an INDEX/MATCH…
-
Returning a value based on one or more of 3 critieria
Hi, I am trying to setup a formula that will return a product description if the entered value matches one of three values. The inventory system we have uses tolling numbers, as well as bulk and final good numbers for identification. Here is an example of the sheet I would be pulling the description from: As long as the…
-
Which is the most efficient formula in this case with multiple conditions?
I want to set up a formula that reflects Status in the Parent row. Below are the conditions: If all CHILDREN tasks are Not Started, then PARENT status is Not Started If any CHILDREN task is In Progress or Completed, then PARENT status is In Progress If all CHILDREN tasks are Completed, then PARENT status is Completed I…
-
Help with IF/Then statement for values between 2 numbers
I manage a sheet where we track Inspection reports and compliance statistics for meeting 24 hour deadlines. I calculate regular submission turn-around time by date submitted - report day. Problem is, that doesn't work for my night shift inspectors because their shift ends on the next day, so they always appear a day…
-
warnings, when a reference, cell link or formula get corrupt
Hi, I was wondering if it is possible to get warnings, when a reference, cell link or formula get corrupt?