-
Simple CountIf
I was looking for a simple COUNTIF formula to search the entire column and only count the cells that have a value. It can be any value. Does anyone happen to know of a formula that would work for me?
-
How to return a cell from another sheet when the criteria is within a text string in the source?
I'm trying to pull the notes from a Request sheet into the Review sheet, but I'm only getting results when the search criteria (Contract #) is the only contract in the cell in the Request sheet. Ex 1: Line 1 in the source, "123" in the Contract #, has "Urgent" in Notes; the current formula returns the correct notes into…
-
How to get specific data from a list on sheet with most recent or higher level of issue?
So, I have a raw data sheet that shows each time an employee receives a type of correction within the organization. I need to somehow extract both the most recent and highest level they currently have based on only certain policies, and I have no idea how to build any formula to pull this needed information, here is an…
-
Index Match Formula help. Index Match of Health status of an activity into Sheet Summary
I have multiple sheets with the same columns (Health, Task Name, Start, Finish). Note that the Health column is a symbol (red, yellow, green, blue). In my summary sheet, I am using the following Index Match formula to search for Task A in Task Name column and spit out Health symbol. =INDEX(Health:Health, MATCH("Task A",…
-
Formula help to JOIN results of LEFT formula down a column
I have a column of values, I'd like to use a Join function to combine all the values into a list, but first i'd like each of these values to be trimmed via the left function. Here is an example of the Left function I am using: =LEFT([ColumnName]1, FIND(CHAR(10), [ColumnName]1)) How do I integrate this into a JOIN operation…
-
Hiding #INVALID DATA TYPE with formulas using NETWORKDAYS
Hello, I'd love some feedback and advice on how to get this to work. I have Start Date, Due Date, Duration and Due in Days columns. For my Due in Days column I am using this formula: =NETWORKDAYS(TODAY(), [Actual Due Date]@row) For my Duration column I am using this formula: =NETWORKDAYS([Actual Start Date]@row, [Actual…
-
Using COUNTIFS and OR statement
You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head. I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark. I want to get a count of PMO flagged rows that fall within several…
-
Index Match Multiple Criteria across sheets
I am trying to create a formula that matches criteria between two sheets, then populates a cell based on the criteria's results. The goal is to use an index/match to populate the "fee" cell in the second picture based upon the client and service level. Could someone explain how to create this formula? Thank you.
-
COUNTIFS + OR - Forumla Help
You're all so amazingly helpful that I'm back. I think this is an easy fix for most, but I'm scratching my head. I have a column named Status with multiple drop down options, of which only one can be used. I also have a column named PMO that is a checkmark. I want to get a count of PMO flagged rows that fall within several…
-
COUNTIFS- CONTAINS/FIND/HAS
Set-up: I have a data prep sheet that references a master sheet and some other sheets so it is easier to set up a dashboard. I have a list of departments in one column (Column5), and the count formula in the next column. The formula works when there is one department listed in the reference but not if there are multiple…
