-
Need formula for % Complete of 3 specific rows in sheet
Hi - My project has 3 phases in it and I would like to be able to show not only the % Complete of each phase but for the project overall. I have each phase working by enabling the dependencies and it is already calculating for those but I cannot get a formula to work to calculate the over all % Complete for Row 1. Does…
-
Count number of dates that meet several criteria
What would be the formula that counts the number of dates that fall between a start and finish date if another column is not blank? Current formula I have is: =COUNTIFS({Dates}, >=[Start Date]@row, {Dates}, <=[End Date]@row) This is returning the total number of dates correctly. But would like it to return the number of…
-
Creating a metrics sheet based off a project intake form
Hello, I'm looking to set up a separate tracking sheet that captures ongoing counts based on our project intake form. I'm hoping to capture: # of requests created by Department (uses a dropdown on the main intake sheet) # of requests per Program (uses a dropdown on the main intake sheet) # of requests by Type (uses a…
-
I am getting Cross-Sheet formula issue which is limited to Maximum Allowed (100000)
Dear All, I am getting below error message. "Some cross-sheet formula can’t be updated, because this sheet has more cell referenced from other sheets than the maximum allowed (100000)" How can I fixed the above issue since I am maintaining history table and all completed records I am taking from historical table using…
-
How can i get the value in column B that matches the value in column A from rows D-K
-
COUNTIFS with multiple IS NOT statements
Hello! I'm trying to write a formula that tells me how many rows meet the criteria in multiple columns. It works with criteria in two columns, but when I try to incorporate a third, I get an incorrect argument set, or an invalid operation. I can't figure out what I'm missing in the formula. Here's the formula that works:…
-
Changing from Vlookup to Index match
I am looking to change the formula below so that when I add columns it doesnt upset connected data. Was looking to change to index match but going round in circles. I can send further screen shots if necessary. Thanks for looking ❤ This is the formula currently in the sheet. =IFERROR(IF(ISBLANK(VLOOKUP(Country@row + " TT",…
-
CountIF at risk
Hi. I'm having trouble adding the second half of a formula. I am trying to build a rollup task summary. So I need a COUNTIF a task is due within 3 days, and the completed column is blank. I think that will get me to display only the task that is approaching their due date.
-
30 days past due warning
Hi, I need to find automation or formula but not sure which. I have a column of due dates, I need a another column to say "30 days" if due date column is over 30 days past due. Any help is appreciated. Thank you Kim
-
INDEX/MATCH to fix #NO MATCH Errors, when row does not exist
Okay, first, thanks so much for reviewing my question, and posting your potential answer. I really appreciate it! Now I am rather prod of myself, until I got stuck that I was able to create what my boss wanted. There are 2 departments that use this sheet: Transformations and Management. Now when it comes to the 1st phase,…
