-
CountIfs between sheets resulting in "0"
I have a pretty extensive risk log spreadsheet that I am trying to condense and simplify. Specifically, I want to filter it into a new sheet that will show me the number of risks and issues coming in per week based on the date they were entered into the log. I have been attempting to use the "Countifs" function, however I…
-
Need help correcting RYGB formula ASAP
My colleague set up a formula I'm using for RYGB column and I need some help interpreting it to figure out why it isn't behaving exactly the way I want it to: =IF(ISDATE([Actual End]@row), "Blue", IF([Working Start]@row > TODAY(), "", (IF([Working End]@row < TODAY(), "Red", (IF(ISDATE([Actual Start]@row), "Green",…
-
Document Checklist(s)
Hi all I am looking for the best way to create a document tracking checklist that tracks all necessary documents in our loan origination process for EACH applicant that may be on the loan. There could be 1 applicant or there could be 5. We could have individuals or entitys on the loans as well. I need to be able to pull…
-
Formula to checkbox when option selected from dropdown
Hello As per the screenshot below, im trying to have a formula that if Status A is selected from the column this will check the box within approved for construction. is this possible. Regards Daniel
-
CountIFS with Multiple Criteria
Good All: I having a difficult time with my formula counting and meeting all criteria. I want the formula to count how many cells have "Not Started" and have the letter "D". Both have to be met in order to be counted. My current formula returns UPARSEABLE Here is my formula below: COUNTIFS({Epicor ERP Data Migration Map…
-
Reference Single Column from Sheet Range Reference
Is there a way I can easily reference a single column from a wide Sheet Range Reference? I have 50 columns on a separate sheet, each one I need to run a COUNTIF() on. Rather than creating 50 range references across sheets, is there a way I can reference the whole range, as you would in a VLOOKUP, but then reference the…
-
Dashboard - Formula help for date fields
Hi I have a column in my sheet that is date specific. I am trying to bunch together how many actions have taken place within each month. E.g. if I have 5 actions, one per line, that have been executed within the month of May (all different dates) please can someone provide the formula that will allow me to make a count of…
-
Multiple IF/AND statements
I am a new user and struggling with some IF statement rules to set color status. For the most part, I am pulling from the status column called “Capability - Stage Gate Status”. Users choose from a drop list. In addition, I wanted to add some criteria for other scenarios, such as the Start Date is past and % is 0%; the…
-
Identify Duplicates with 2 criteria
Hello, I am trying to flag duplicates that meet 2 criteria. I have a sheet that has Request type actions (Add, Revise, Delete, etc.) and also a Part ID column. I am trying to identify duplicate Part ID that also have the same Request type. See screenshot. Ex: Row 1 and 4 should flag as duplicates as they are the same part…
-
Invalid Value Error with New Year
Hello! I have created a formula for 4 months after a specified date column. The problem is, when that 4 months goes into next year, I receive the "#INVALID VALUE" error. For example, if my formula is using the date of 08/31/19, I receive the proper formulated response of 12/31/19...but if I change the date to 09/01/19, I…