Trending in Formulas and Functions
-
How do you set a flag status if a date is in the past and status does not equal a certain criteria?
Hello! I’m having trouble getting a flag to turn on if my Production Wraps column date is in the past and the status is NOT “wrapped” or “wrapped/aired”. Here’s the formula I’m trying to use but am getting #incorrect. Any suggestions? =IF(AND([Production Wraps]@row > TODAY(), OR(Status@row <> "Wrapped", Status@row <>…
-
MAX DATE FROM 3 COLUMNS
Hi, On a separate sheet I would like to capture the max (or last) date from another sheet. As shown below, I would like to log the latest "DATE OF VISIT" from the 3 treatment columns. In this example the correct date would be 9/06/23. I've tried multiple versions of MAX(COLLECT but am only getting the first date, not the…
-
INVALID DATA TYPE Error in single cell of column formula
Hello, I am getting one cell returning the "INVALID DATA TYPE" error in a column formula. I have 159 rows in this sheet, and only one cell has the error, so I am very confused. The formulas is: =COUNTIFS({Site Visits Range 1}, Type@row, {Site Visits Range 3}, [Primary Column]@row, {Site Visits Range 2}, <>"", {Site Visits…