Autoupdate column with a condition without edit row

[Mark_11]

Hello,
i have a certain number of rows in a table.
I have a deadline colum; i would like to auto set the value of another enum column like if([deadline]<today(),“EXPIRED”,“ON GOING”).
Something like a calendar trigger; i don’t want to enter in that row to edit some value in order to trigger a workflow “set value…”. I’d like to see an auto update of my database.

Is it possible?

[Aleksi]

One way is using virtual column which will recalculate the result everytime when you sync.

[Mark_11]

Ok,
can you go a little deeper on that?
Do i need to put the same formula in virtual column instead of a enum column?