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:
works great thanks guys
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
User | Count |
---|---|
35 | |
34 | |
27 | |
23 | |
18 |