Hi all,
I am working on a database of products with expiry dates. What I am trying to achieve is to have a column name "Status" to show whether the product is "Valid" or "Expired", and the column can auto update the status to "Expired" when it passes the expiry date. Anyone has an idea on this?
Solved! Go to Solution.
You can have a virtual column with the following app formula:
IF(TODAY() > [date], "Expired", "Valid")
User | Count |
---|---|
15 | |
10 | |
9 | |
7 | |
3 |