AppSheet itself does not have a way to “schedule” an update to the data. Typically these kinds of updates are best left to backend processing anyway such as with Google Scripts in the sheets or procedures in a database. Front end resources, i.e. users displays, are then not bogged down with this processing effort.
However, I would like to offer this.
I presume you want to update the ACTIVE column in order take action on rows that are “active”? Wouldn’t it be almost as easy to test that:
AND([Start Date] >= TODAY(), [End Date] <= TODAY)
This is equivalent to
[Active] = "Yes" but without the need to create and maintain a process to keep [Active] updated.