Warning message based on expression

[Cmath06]

Hello, I am trying to make a virutal column that displays a warning text message if an expression is valid. I currently have a form where I input a serial number. In the virtual column I want the warning message to show up if that serial number has been used/scanned in the last 30 days.

Here is my expression so far but I’m getting an error.

   IF(
   COUNT(
   FILTER(
   "Delivery",
    AND(
           ([SERIAL NUMBER] = [_THISROW].[SERIAL NUMBER]),
           ([SERIAL NUMBER] = [Delivery].[SERIAL NUMBER]),
           (TOTALHOURS(NOW() - [TimeStamp]) < 30 * 24)
            ))
  ) > 0,
  “This serial number was scanned within the past 30 days”,
  ""
 )

The sheet with the Serial Number column is called Delivery. Any Ideas on how to fix it?

[Marc_Dillon]

Cmath06:

but I’m getting an error

Which is?

---

Cmath06:

I am trying to make a virutal column that displays a warning text message if an expression is valid

Did you mean “is NOT valid”? And are you aware of these fields in a column definition? Could use those instead of a virtual column.

[Cmath06]

I fixed my error, had the wrong column name. My virtual column is to check if the serial number has been used in a previous row. It doesn’t necessarily need to check validity just check to see if it has been used in the past 30 days. If there is a way to create expression in the if valid section that will work too.