-
=COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) Formula help!
Currently using =COUNTIF(CHILDREN(), 1) + " of " + COUNT(CHILDREN()) with check-boxes as a quick look to tell how many deliverables have currently been accounted for. I need to add additional lines under the parent row, but don't want them to count toward the total shown at the top. Is there a way to do this?
-
Every 5th Value
I have a range that is 1 row high and twenty-some-odd columns wide. I need to AverageIF() some of the values in this field together, starting by looking at only every 5th column and then if they're not equal to 0. The 0 part is easy, as is setting up the AverageIF(), but where I'm having trouble is in finding a way to get…
-
Conditional Index Match with Date => TODAY
Hello! I'm stumped on how to do a conditional index match (or index collect) between two sheets. I'd like to pull in a budget number from another sheet (based off of the project's acronym) if and only if that budget number's end date is in the past. The sheet that I am indexing into will only have the project's acronym…
-
Nested IF statement
I am trying to allow the % Complete column update the Status column. My Status column has 3 choices, although I've unchecked the box requiring the use of a dropdown choice only. This is the formula that I've written, but it returns the error "Unparseable". Any thoughts would be appreciated! =IF([% Complete]@row = 1,…
-
Split Text to Column
Hello I have been trying to make this happen but am not quite there yet. I have the following column that contains CAH- Moraine. I am only trying to pull Moraine into a new column. The formula below is not quite right. Anyone have any ideas? =RIGHT([RECIPIENT COMPANY]@row, FIND("- ")) Thank you!
-
How to collect the same data in time
Hi, I have a project management sheet which has a column named "Completion %". I want to read the value of that column for specific lines every Friday and use this data in a chart on a dashboard. What's the best way to do this? I would like to use a data grid to collect the data each week, the challenge is to keep past…
-
Looking for Matches
I have two columns of data. One column I know is correct, the other has the same information but is a manual entry with possible human error. I am looking for a way to compare the two cells to see if the info matches. For instance the first column may have 220656 and the column next to it may have 220655. I need a way to…
-
Adding a COUNTIF to a COUNTIFS formula?
I have a COUNTIFS formula... =COUNTIFS(Status:Status, CONTAINS("In Progress - On Track", @cell)). I have another formula that I need to add to the =COUNTIFS forumula... it's =COUNTIF(Level:Level, =0) . How would I combine the two?
-
Start and end date line chart
Hi Team, Can anyone help me how can I create a line chart based on below information. I
-
Adding months onto a date
Hi sorry I have seen this posted multiple times before but I can't get mine to work. I am trying to add the number of months in the "Monthly Review Frequency" to the "Previous Review Date" in the "Next Review Date" Column. I have tried this formula: =DATE(YEAR([Previous Review Date]@row), MONTH([Previous Review Date]@row)…