Automate column base on today's date

[Christopher_Roq]

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”

[Koichi_Tsuji]

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.

[Steve]

For reference:

help.appsheet.com

Virtual Columns

Check out how you can use virtual columns to add more information to your app.

[Christopher_Roq]

works great thanks guys

[Ahmad_1]

Hello, my friend, how are you
Can you help me I'm a new user
What I'm trying to do is I have a Contract Status column which will say "ACTIVE" or "EXPIRE" and the column rule will automatically update on our calendar date today.
I want you to send a video of how to do this to apply the method or work photos