Autoupdate column with a condition without edit row

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?

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

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