Modify status automatically

[Adolfo_Enrique_]

Hi, I need help with the following.
My app contains a table where I save orders, a column represents the status of my orders.
I need to be able to automatically modify the status of an order, for example when the current date is May to the scheduled date.
Try adding the following formula:
if ([Scheduled Date]> NOW (), “In Progress (Within Date)”, “In Progress (Delayed)”) as a state data formula, but I am unable to change it.

How do I have to execute this formula automatically, and chang e the value in my table?

Thank you very much for the help!!