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?
Which is?
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.
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.
User | Count |
---|---|
43 | |
26 | |
24 | |
14 | |
12 |