Column data auto update

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 Solved
0 2 104
1 ACCEPTED SOLUTION

You can have a virtual column with the following app formula:

IF(TODAY() > [date], "Expired", "Valid")

View solution in original post

2 REPLIES 2
Top Labels in this Space