-
VLOOKUP No Longer works with same formula
This worked right before New Year's. Now for some reason it says Incorrect Argument Set?=VLOOKUP(Email@row, {RRFP Sales Log 2025 Total Cost}, 13, false) Basically I have the clients' email in the Primary Column for Smarthseet 1 and 2. I sheet 2 is RRFP Sales Log 2025 and Total Cost is the name of Column I need pulled from…
-
Percent formula for drop down fields
I have a column with the following options for drop down fields: NA, Not Started, Required, Drafted, Posted What formula can I use to show me % complete (posted) without taking into account the NAs?
-
New! TIME function for formulas
Hey Community, Some of you may have noticed a new function in our Functions List last week… Introducing the TIME Function! This returns the time of day in 12- or 24-hour format from a given set of values. Syntax TIME(time_value, [ format ], [ precision ]) time_value — The value to create time with. Must be provided as a…
-
COUNTIF Formula Returns Zero in Sheet Summary
I have a very simple COUNTIF formula that isn't working in the sheet summary section. For example, I'm trying to count how many times the year "2017" appears in a column called "Tablet Year". The formula should be: =COUNTIF([Tablet Year]:[Tablet Year], 2017) I've also tried surrounding the "2017" in quotation marks in case…
-
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…