-
count an instructor only if last name is different
We send instructors to teach globally. I need to keep count of instructors on the field, quarterly. Sometimes 1 instructor goes to teach 2 courses. So the count would be 1 instructor, 2 courses. Sometimes 2 instructors go to teach 2 courses. So that count would be 2 instructors, 2 courses. This formula seems to work where…
-
IF Statement
How can I combine the following two formulas in one statement: 1) IF([Patient Date of Birth]1 OR [Last Patient Visit Date]1) = BLANK OR NULL) THEN ([Patient Date of Birth]1 AND [Last Patient Visit Date]1) = "1/1/1940" 2) IF(NETDAYS([Patient Date of Birth]1, [Last Patient Visit Date]1) / 360 > 12, DATE(YEAR([Last Patient…
-
Count If Children
Good Day All: I am trying to count the Children and grandchildren in my Status Column that meet a specific criteria. Currently its counting the parent and grandparent in that column Current formula: =COUNTIF(Status:Status, "Ahead") Thanks
-
At Risk Flag Formula
Hello, I have a number of "parent rows" with children indented just underneath. Each parent row contains a keyword "launch". I'm hoping someone may be able to assist in a formula. What I am looking for in theory, if any children indented rows are flagged at risk, the formula would then flag at risk for the parent row.…
-
Dynamically Calculate Child Counts Based Upon Filters.
Hi All, How do I calculate the count of children in a parent row and have it dynamically change depending upon filtered results. I’ve tried COUNTIF and COUNT plus SUM CHILDREN and they all work showing the correct number of children before a filter is applied. When I apply a filter, the number of child rows reduce, based…
-
Problems using @cell with dates when range contains blank cells
Hi, I've been trying to use this formula: COUNTIF(Due Date, MONTH(@cell) = 8, but it returns an error INVALID DATA TYPE If I limit the data range to exclude the blank rows than it has no problems. But this is not pratical because later when I more tasks, I have to adjust the formula. Interestingly SUMIF does not have this…
-
Link count and Ranges - Does each column in a range count as a link?
Hi Folks, After reading up on the issue of cross sheet link limits, I would like to confirm what 'counts'. If a range is defined as having 10 columns does that count at 1 link or 10? If a range has 20 columns is that 20 links or one? And finally if that same range is used for several VLOOKUP functions in a destination…
-
index/match help
Please refer to the attached image. I would like to create a formula to display just the "Preliminary" cost for "Atlanta - Cumming" on a separate sheet using the index/match formula but keep getting an error. Can anyone help with this? I am open to using another function as well.
-
Multiple checkboxes
Hi there! I have two columns, for the sake of this example we can call them A and B. I would like to create a formula so that if A and B are both checked off, it will show the text "Sent" but if only A is checked the text will say "Reviewing". If neither checkboxes are marked I would like the text to read "Pending". Can…
-
Calculate End Date from "Start Date Plus Number of Days (calculated and rounded up via formula)"
Hello Community! I'm trying to calculate End dates based off of a hard Start date, and adding a number of Days that I have listed in another cell. The number of Days is calculated via formula, from one cell that lists Project hours (which I manually input) and each project is assigned to a crew, which have different…