-
Countifs based on current month turnaround times
Good Morning! I am trying to create a graph based on the current month's turnaround times. I tried the following, but it returns as #Unparseable. =COUNTIFS({Turnaround}, <=3, {Date Fufilled}, Value(@cell) = Month(Today)) Is this even possible? Thanks
-
Calculate due date based on last reviewed date
The policy was reviewed on June 1, 2019, I want the next due date to be in 365F both columns are date fields Formulas I tried- =[Column4] + [365] = Reviewed Date + 365 fx=Reviewed Date + 362
-
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…