-
I am coming up with formula errors when trying to make the parent flag red if any children are red
The CHILDREN have, for example, =IF(AND([End Date]323<TODAY(),[% Complete]323<>"1"),1,0) and that works to turn flag red in all children but tried all kinds of COUNTIF formulas to also turn the parent red if any one or more of the CHILDREN are flagged red but all attempts are failing. Any ideas?
-
Formula IF and NOT Validation
I am trying to check a flag when two conditions are met: End Date is past Today's Date Status is NOT "Complete" I am sturggling with this for some reason and cant see where I missed something: =IF((TODAY() > End@row, NOT(Status@row = "Complete", 1,0))) Any pointers would be helpful.
-
Score formulas
We are having a sales contest this month. The teams (Houses) entered their numbers and we are ready to Identify the winners for 1st, 2nd and 3rd place. I was able to identify the 1st place score (Highest Score) using the MAX function and the name of the House (Top Team) with the JOIN function. BUT, I cannot identify the…
-
Formulas within conditional formatting?
I believe this must be possible, right? I have two column 2 my on hand amount and column 4 my par. I want the row to highlight red if the on hand amount is less than the par. Tried to use @row within the conditional formatting but it seems only be highlighting when the on hand amount is less than 1 not less than the par…
-
nesting properly?
Hi all and good afternoon, im working on a sheet that seems to be giving me an issue and I am aware its my lack of knowledge. Hopefully someone from the forums can give me some insight as to how to achieve my desired result. I have a cells contents with: =-SUMIFS({Transactions Range 1}, {Transactions Range 4}, ="Issue",…
-
7 Day Average/30 Day Average
I am trying to build a formula for a data set that I can calculate as a complete average, but I'd like the 7 day average and the 30 day average. Here's the formula that works: =AVG([% Successful]:[% Successful]) I know I will need to use AVERAGEIF, but can not get the date parts correct. Thanks for your help!
-
I need to SUM points based on user and then sort by aggregated points
I have a sheet similar to the one below: I need a way to display my results like this: I can create a report but it won't sort it based on the aggregate function. Any help would be much appreciated.
-
Does anyone know if its possibly to use INDEX MATCH to pull in images?
The formula seems to be working but it pulls in the PNG name and not the image. although the image name doesn't match. I am not sure what is going wrong. it looks like it is pulling in the name of the last icon image. Does anyone have any tips?
-
Why is MONTH returning the wrong month?
I'm using the MONTH function against a Created system column. This Created column has date and time. For values on the last day of the month after 8pm MONTH is returning the next month. For example: Created = 9/30/2021 8:52pm MONTH returns 10 I'm guessing that this is because the system column is actually storing the time…
-
Extract a Number from a cell, the position of the number varies
Problem: I have a task name column and within this contains a number that I'm trying to extract. The number is always formatted with CRXXXXXX. The location of CRXXXXXX in the column varies from row to row. Goal: I want to extract the number from the task column. Example: CR123456 would be 123456 a new cell. I have seen…