-
Do Not Apply Formula IF Field Is Blank
I am trying to calculate a variance by subtracting two columns but only if one of them is not blank. I'm having trouble getting the ISBLANK condition to work. My current formula is =[Budgeted Total]4 - [Amount Spent]4 but I only want to apply that formula if Amount Spent is not blank. Any suggestions would be very much…
-
Countif "#INVALID OPERATION"
Hi Im trying to count all "#INVALID OPERATION" in order to catch if someone has enter an invalid character etc in a cell which needs to be added up. I have tried multiple things without success. The following is using the New "contains" function which returns a larger count than it should. =COUNTIF({O_Eq_Total_Hrs},…
-
Sumifs with 2 conditions from same column
I am having trouble creating a formula with 2 conditions. I currently have formulas in a Spend summary sheet that only have one condition but I need to add a 2nd condition. Here is what I have for 1 condition: =SUMIFS({Team DD - Budget - FY19-FY20- Amount}, {Team DD - Budget - FY19-FY20- Requester Team}, "Computing", {Team…
-
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…