Formulas
Discussion List
- Hi, So I have the following sheet set up for projects where each Group may have more than one project in different statuses: The order of status are the following: 1) Started, 2) In Progress and 3) Co…
- 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?
- 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:…
- 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…
- 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…
- 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…
- 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(TODA…
- 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 …
- 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 sec…
- 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 …
