-
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…
-
IF Formulas for Status Columns
Hello, I'm looking for assistance in writing an IF formula to change a cell's value based on the value of other cells in the same column. Specifically, the values will be symbols. If all symbols are green, I'd like the first row to show as green, if any are yellow, then the top row should be yellow, and lastly if any are…