-
Is there a prettier way to write this formula?
Is there a prettier way to write this formula? =IF(MONTH(Finish@row) = "1", "Q1", IF(MONTH(Finish@row) = "2", "Q1", IF(MONTH(Finish@row) = "3", "Q1", IF(MONTH(Finish@row) = "4", "Q2", IF(MONTH(Finish@row) = "5", "Q2", IF(MONTH(Finish@row) = "6", "Q2", IF(MONTH(Finish@row) = "7", "Q3", IF(MONTH(Finish@row) = "8", "Q3",…
-
Average/Roll Up Harvey Ball % Complete Symbol in Parent Row
Hello, I have a feeling this is going to be so simple, but I cannot seem to figure out how to average the values of the Harvey Ball % Complete symbol in a parent row. Per my screenshot, I want the Harvey Ball with the red arrow to average the values of the Harvey Balls beneath it. There is a parent/child relationship…
-
Get total cost based on multi select
Hi everyone, I have a total column that I want populated with a dollar amount. I want this to be dependant on the specific services selected from a multi select. The trick here is that the services rendered are completed by different vendors with different prices. So, the multi select prices will change based on the…
-
Symbols and formulas
I have a sheet that has 4 dates on it that I want to use symbols for completion purposes but I cannot figure out the formula or if it is even possible. I am trying to use the status bar with Empty, Quarter, Half, Three Quarter and Full. Here is what I would like to happen. If Date 1-4 are greater than today I want it to…
-
How to count on another sheet how many terminated employees per month?
Hello, I am trying to use the following formula in another sheet to count how many employees were terminated on the system per month: =COUNTIFS({Status}, @cell = "terminated", Month@row, {Turnover per month 2021 Range 4}, Year@row, {Turnover per month 2021 Range 2}) What am I doing wrong?
-
How to count children rows with multiple criteria
I have tried this many ways and can't figure it out. The column names I am working with are: "CaseRegNum", "Type of Review", and "Status". Each parent row is a different year and beneath each year are cases IDs (these are in the caseregnum column). The cases are categorized into "general" and "special" (this is the type of…
-
Formula Help Countifs and Match
I'm trying to develop a cross sheet formula that will give me an error message if I've over-allocated equipment. This is What I've come up with so far but I get Incorrect argument. =IF(COUNTIFS(MATCH([Equipment Required]@row, {Equipment Total}, 1), >[Equipment Max#]@row, {EDBDate}, >=Start@row, {EDBDate}, <=[Last…
-
If Statement Between Two Numbers
Hello, I am trying to set the status based off %complete. I believe my formula is correct, but am unsure why the status column isn't updating based on the formula. May somebody help me out and please let me know what is possibly missing? Thank you!
-
Average distance travelled in a particular date range by each team
Hi Community, Can you help me with a formula to find the average distance that Team "Blues" travelled in July? Many thanks, Ahmet
-
Count the number of non blank child cells
Hi! The sheet contains the following hierarchy: There are formulas (COUNT(CHILDREN())) in the blue cells of the Missing study column. I need to count the total number of white (child) cells. In this particular case [10] should appear. What the formula should look like? Thank you in advance!