-
#UNPARSEABLE using COUNTIF and cross-sheet Reference
This feels like a dumb question. I'm trying to get a count of total "To Do" items in the entire Status column from the Team SCRUM: Communications sheet. This function is working fine without the cross-sheet reference, but nothing I've tried is working to correct the issue. The formula is as follows: =COUNTIF({Team SCRUM:…
-
COUNTIFS with Date range with @row
I have the current formula that counts the start date but I wanted to see if i could do a range of dates from start date to end date and count those. Any Advice? =COUNTIFS([Staff Team]:[Staff Team], [Staff Team]@row, [Start Date]:[Start Date], [Start Date]@row)
-
=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?