Automate column base on today's date

hi guys,

maybe you can help me i’m a new user- what I’m trying to do is i have a column “contract status” that will update an “ACTIVE” or “EXPIRE” and will automatically update the column base on our calendar today’s date.

i have a formula below that wont trigger or update the column
IF(([EXPIRATION DATE] <TODAY()+1) ,"Expired","Active")

today’s date is feb 6,2021 already passed date but the column status is still on “Active”

I simply suspect you are pushing this expression into the physical column rather than column.
So the data is not being updated, unless you edit each row.
To dynamically change the value, create virtual column for CONTRACT STATUS and utilize the same, avoiding to use physical column.


For reference:

1 Like

works great thanks guys

1 Like