-
Within the last 12 months
I can't get my formula to pull violations reported only within the last 12 months. Can someone see what I am missing? =COUNTIFS({Compliance Master File V2 EE-number}, [EE Number]@row, {Compliance Master File - Compliance Category}, "Reinstatement"), AND({Compliance Master File V2 Violation Date}<=[Today]@row, @{Compliance…
-
Match Multi Values to a Table?
Hello, I am trying to figure out how to VLOOKUP or MATCH or something else to return values from a table. In the example below, in the highlighted row, I would want it to return the three highlighted 'Assigned To' values in the table below. Is this possible? Or is there a better solution that I am not thinking of?
-
IFERROR and january dates for previous month (and Year)
Happy New Year All. I have successfully had help in navigating the problems of "Previus" month when a new year like now for both COUNTIFS and SUMIFS However, I have a simple IF statement and just cannot get it to work. 4 fields Date & Time - this is the automated date creation value This Month - dropdown with True or False…
-
Formula Help - Conflict Check Across Multiple Sheets
Greetings! I have been trying to figure out a formula that will solve a problem. I have a column in schedule that I would like to show "Conflict" if the contact@row is scheduled on the current sheet and on a different sheet within the same date range. I have an easy conflict check for whether someone is scheduled on the…
-
Help with excel formula please
I am trying to accomplish the following in a new hire training plan: I have a column for Expected Start Date(D4), Start Date (E4), Actual Completion Date (F4) and Status (G4). I want the status column (G4) to reflect the data placed in the other cells. If only D4 is populated, then G4 should say "Not Started". If D4 and E4…
-
Updating cells to Formulas
I have a sheet that we track miles for vehicles for services so 1 column is for a A the next B service. those columns set of formatting against currant mileage and let the mechanic know if a service is due. the issue we have is the A is every 18K miles the B is 36K miles. When a B service gets done it resets the A service…
-
Merged: Viewing window for Formulas
This discussion has been merged.
-
Merged: Enable move of formula editor window
This discussion has been merged.
-
Index/Match Formula
Hello, I am needing advice on using this cross sheet formula to produce values in a cell. I have one sheet that is populated by responses to a form. I have another sheet with a list of people and their contact details. As the form responses come in to the sheet, I would like their answers to also populate on the other…
-
text to columns
Hello. I'm looking to split out the following string to provide just the supervisor name and I've yet to figure out the formula.. thoughts on how I do that in a helper column? Thanks Supervisor | Approved by Little, Paul on 12/4/23 @ 11:42 AM |