-
COUNTIFS for year within criteria
I am pretty new to using formulas. I'm working on a dashboard for one of my sheets and I want to show how many escalations a plant has had this year alone. Here is what I have so far: =COUNTIFS(([Plant]:[Plant], "Changzhou"), IFERROR(YEAR(@cell), 0) = 2019) I've tried many different variations based on my scouring of this…
-
Add lines in templates and have the formulas auto appear
Hi, So I created this template for our sales team. The idea is that in the yellow boxes they enter item number and quantity (and other things based on where they are in the template) and was informed that there are some sales orders where they will need to add additional boxes. We were looking to have it set up so that one…
-
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…