-
linking value from parent cell
EDITED: i found the =PARENT function the listed as this in the cell but my cell is turning out blank! =PARENT([Topic & Subsequent Action Items]13) Its recognizing the function as the cell i want to reference is outlined in blue... HELP! the function initially worked when the Meeting date row was a child of the "upcoming…
-
Return sum of one column if today's date is between A and B, etc
Hi guys, I can get the following formula to work without issue: =IF(TODAY() = DATE(2019, 8, 9), SUM([2019 Aug]:[2019 Aug])) What I can't do is update the logical expression to be if today's date is between Aug 1 and Aug 31. Essentially I want a self-updating formula that will always show me the sum of the appropriate…
-
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.…
-
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…
