Warning message based on expression

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?

0 2 203
2 REPLIES 2
Top Labels in this Space