-
Using COUNTIFS with AND
Hi! I'm trying to count the number of items which have one status as "Operational" and another status with any option EXCEPT "Operational". This is the formula I have but it is getting an error as UNPARSEABLE. Note that I'm using a cross-sheet reference. Thanks!
-
#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…